topic Re: Hiding column headers in PowerPoint report in Qlik NPrinting

Hiding column headers in PowerPoint report

danielact — Wed, 25 Sep 2019 18:40:54 GMT

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?

Re: Hiding column headers in PowerPoint report

Daniel_Jenkins — Tue, 10 May 2016 21:34:45 GMT

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.

Re: Hiding column headers in PowerPoint report

danielact — Wed, 11 May 2016 12:04:05 GMT

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

Re: Hiding column headers in PowerPoint report

avinashelite — Wed, 11 May 2016 13:24:30 GMT

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

Re: Hiding column headers in PowerPoint report

danielact — Wed, 11 May 2016 13:33:13 GMT

Yes, already tried that. Didn't help.

Re: Hiding column headers in PowerPoint report

Daniel_Jenkins — Thu, 12 May 2016 01:12:17 GMT

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.

Re: Hiding column headers in PowerPoint report

danielact — Thu, 12 May 2016 14:43:51 GMT

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.

Re: Hiding column headers in PowerPoint report

Anonymous — Tue, 25 Jul 2017 16:01:45 GMT

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

Re: Hiding column headers in PowerPoint report

Anonymous — Tue, 25 Jul 2017 16:31:32 GMT

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

QlikView version 12.10 (SR7)

NPrinting version 17.4.0.0

- Claus