Hiding column headers in PowerPoint report

[danielact]

I'm bringing in specific columns from a Straight Table to a PowerPoint presentation. I want to suppress the header rows, but NPrinting won't seem to do it. I checked the suppress header row option in QlikView, and in QV it doesn't show them. How can I hide them in my PowerPoint template?

[Daniel_Jenkins]

Hi Daniel,

Suppress the header in QlikView and un-check Header Row in the PowerPoint Report template (TABLE TOOLS > DESIGN > Table Style Options).

HTH - Daniel.

[danielact]

It's already unchecked. Doesn't seem to help.

[avinashelite]

if your able to hide the header in the QV then did you tried checking the keep source formatting in the template design ??

[danielact]

Yes, already tried that. Didn't help.

[Daniel_Jenkins · Accepted solution]

Hi Daniel,

I was about to attach a sample project demonstrating this but decided to check it one more time before posting. I was surprised to find that the behavior does not persist! I can make it work consistently as long as the NSQ is open, but once I close it this behavior is lost. I then tried using PPTM format & VBA to remove the first row programmatically but PowerPoint does not have an "on Open" event so I gave up. Sorry I don't have a working solution at this point.

- Daniel.

[danielact]

It looks like a bug in NPrinting. I actually previewed a report twice - the first time it hid the headers, and the 2nd time it didn't. Not only that, if you show the headers and then modify the text in QlikView, it sometimes gave me 2 headers, once with the original text, and once with the new text.

[Anonymous]

Hi Daniel Jenkins,

I also have all of these issues and it even applies to cell formating (all cells with QlikView formatting gets white background so I can see that NPrinting is actually detecting that there is a custom format, but all my colors are not displayed)

If I re-insert headers I also get a dublicated header row, where the second header row has the format as if it was a normal record:

However it is not persistent if I do enough changes then suddently a single table might be displayed correctly for a short time??

I have used the following settings in QlikView and in NPrinting:

This thread is over a year old, has there been any fixes yet?

QlikView version 12.10.0.0

NPrinting version 16.5.0.0 (SR5)

- Claus

[Anonymous]

I have just updatet to the following versions but the issues persist:

QlikView version 12.10 (SR7)

NPrinting version 17.4.0.0

- Claus