Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

How to display a long table (over 1000 lines) into a pixel perfet report ?

Hi experts,

I'm designing a Pixel perfect report and I have to display a table which contain over 1000 lines and we want to display all these lines without a scroll bar.

Can you give me an advice on how we can manage this issue please ?

There is an example of what we don't want to display in attachments.

Thanks,

6 Replies
Highlighted
Not applicable

Re: How to display a long table (over 1000 lines) into a pixel perfet report ?

when you create your pixel perfect report, you do not want to bring in the table as an image.  Bring it in as a level and for the columns you want place in the Detail and the Detail1 section of the level report.  This will create both the headings and the report detail row by row.

you can then use the settings/properties for the header portion to control having/not having headers repeat on each page

Highlighted
Not applicable

Re: How to display a long table (over 1000 lines) into a pixel perfet report ?

if you have access to the NPrinting training environments, there are very good tutorials and examples

you can also refer to the link below

Is there a specific reason you are using PixelPerfec.?  Excel or Word manages tables and table headers extremely well

I have attached a zip file of the training environment.  If you open the nsq and go to reports - PixelPerfect, there is a good example of header rows repeating

Highlighted
Not applicable

Re: How to display a long table (over 1000 lines) into a pixel perfet report ?

with 1000 lines, the report will obviously be many pages - you can use page numbers and other formatting for this as well

Highlighted

Re: How to display a long table (over 1000 lines) into a pixel perfet report ?

Adam is correct: bring in the table as a level and then it will be split in the report by the limits of the page dimensions.

Here is another tutorial around PixelPerfect tables, showing you how to add headers and footers, if you want to repeat them on each page, and how to summarize your data in the table: How to Add Totals and Subtotals to PixelPerfect Reports – Customer Feedback for Vizubi

Support
Support

Re: How to display a long table (over 1000 lines) into a pixel perfet report ?

Hi Aziz,

It is possible to manipulate PixelPerfect report properties to get a large number of rows on one page. I have managed to fit 1000 rows on a single page using Paper Kind = Custom and Roll Paper = True

Please see sample project attached. Extract to C:\Temp\AM to preserve the paths used or you will need to change them in the NSQ.

HTH - Daniel.

Highlighted
Not applicable

Re: How to display a long table (over 1000 lines) into a pixel perfet report ?

Aziz

have you been able to build your report successfully?