topic Re: Repeat headers Nprinting 17 reports in Qlik NPrinting

Repeat headers Nprinting 17 reports

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

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!

Re: Repeat headers Nprinting 17 reports

pmoreno17 — Mon, 13 Aug 2018 08:35:47 GMT

Hi Federica,

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

I hope this can help you!

Re: Repeat headers Nprinting 17 reports

Daniel_Jenkins — Mon, 13 Aug 2018 08:42:54 GMT

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.

Re: Repeat headers Nprinting 17 reports

federicacci — Mon, 13 Aug 2018 12:44:33 GMT

It works! Thank you very much!

Re: Repeat headers Nprinting 17 reports

padmashini_rama — Fri, 21 Sep 2018 11:12:59 GMT

Hi Daniel,

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

Regards,

Padma

Re: Repeat headers Nprinting 17 reports

padmashini_rama — Fri, 21 Sep 2018 12:01:41 GMT

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

Re: Repeat headers Nprinting 17 reports

yanf7 — Sat, 16 Mar 2019 23:36:01 GMT

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?