Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Repeat headers Nprinting 17 reports

Hello,
I'm using Qlik NPrinting 17 (September 2017 version).


I created an xls report and pdf output in the task with a very long table.

The table occupies multiple pdf pages and I would like to repeat the table headers in all the sheets.
In QlikView reports it could be done with the multi-sheet option.
Is it possible in Nprinting?


Thank you!

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Support
Support

Re: Repeat headers Nprinting 17 reports

Hi Federica,

If you want PDF output I suggest you use PixelPerfect type reports. Having said that, you can still achieve what you want if you continue to use Excel and set final output to PDF.

Example:

Lets say you have an Excel template set up like this

You can set the first row to repeat on every page like this

Preview as PDF to get

HTH - Daniel.

View solution in original post

6 Replies
Highlighted
Contributor II
Contributor II

Re: Repeat headers Nprinting 17 reports

Hi Federica,

  1. Click the [Page Layout] tab > In the "Page Setup" group, click [Print Titles].
  2. Under the [Sheet] tab, in the "Rows to repeat at top" field, click the spreadsheet icon.
  3. Click and select the row you wish to appear at the top of every page.
  4. Press the [Enter] key, then click [OK].

I hope this can help you!

Highlighted
Support
Support

Re: Repeat headers Nprinting 17 reports

Hi Federica,

If you want PDF output I suggest you use PixelPerfect type reports. Having said that, you can still achieve what you want if you continue to use Excel and set final output to PDF.

Example:

Lets say you have an Excel template set up like this

You can set the first row to repeat on every page like this

Preview as PDF to get

HTH - Daniel.

View solution in original post

Highlighted
Contributor
Contributor

Re: Repeat headers Nprinting 17 reports

It works! Thank you very much!

Highlighted
Partner
Partner

Re: Repeat headers Nprinting 17 reports

Hi Daniel,

It works for row level header, please suggest the settings to repeat the column header as well, thanks.

Regards,

Padma

Highlighted
Partner
Partner

Re: Repeat headers Nprinting 17 reports

HI,

Row header should repeat it from 8th row, so I have changed the Row to repeat at top as "$8:$8" and it works . Column to repeat at left option is changed to "A8:$A", but its not working so please suggest, Thanks.

Regards,

Padma

Highlighted
Contributor II
Contributor II

Re: Repeat headers Nprinting 17 reports

Hello All.

Using September release NPrinting and Excel 2010. Tried everything but for some reason both PDF and Excel versions don't have repeated row. Any suggestions?