Repeat headers Nprinting 17 reports

[federicacci]

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!

[pmoreno17]

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!

[Daniel_Jenkins · Accepted solution]

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.

[federicacci]

It works! Thank you very much!

[padmashini_rama]

Hi Daniel,

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

Regards,

Padma

[padmashini_rama]

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

[yanf7]

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?