Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Partner
Partner

Hiding column headers in PowerPoint report

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?

1 Solution

Accepted Solutions
Support
Support

Re: Hiding column headers in PowerPoint report

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.

8 Replies
Support
Support

Re: Hiding column headers in PowerPoint report

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.

Partner
Partner

Re: Hiding column headers in PowerPoint report

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

Re: Hiding column headers in PowerPoint report

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

Partner
Partner

Re: Hiding column headers in PowerPoint report

Yes, already tried that. Didn't help.

Support
Support

Re: Hiding column headers in PowerPoint report

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.

Partner
Partner

Re: Hiding column headers in PowerPoint report

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.

cjacobsen
New Contributor

Re: Hiding column headers in PowerPoint report

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:

double header.png

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:

suppress header row.PNGNPrinting table settings.PNG

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

cjacobsen
New Contributor

Re: Hiding column headers in PowerPoint report

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

QlikView version 12.10 (SR7)

NPrinting version 17.4.0.0

- Claus