Discussion Board for collaboration on Qlik NPrinting.
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?
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.
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
I hope this can help you!
It works! Thank you very much!
It works for row level header, please suggest the settings to repeat the column header as well, thanks.
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.
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?