topic Re: How to get larger tables into PDF output format in Nprinting. in Qlik NPrinting

How to get larger tables into PDF output format in Nprinting.

gokulnath2592 — Fri, 17 Jun 2016 04:46:46 GMT

Hi All,

I have a pivot table in my Qlikview reports which has 15 columns and more than 35 rows of data.

Since it is a pivot table not able to generate it in PixelPerfect and save it in PDF output format. On trying with PPTX and XLSX formats to generate the reports and save it as PDF output format we are losing some of the rows or columns. Not able to display the tables properly.

Thanks,

Gokul

Re: How to get larger tables into PDF output format in Nprinting.

avinashelite — Fri, 17 Jun 2016 05:18:16 GMT

How your recreating the Pivot table in NPritning ?? as a image or table ?? I would suggest you to use word or XLSX .

If you import the Pivot table as a image that would help you I guess

Re: How to get larger tables into PDF output format in Nprinting.

gokulnath2592 — Fri, 17 Jun 2016 05:26:42 GMT

Hi Avinash

Thanks for your reply. But the table size is huge. I have a total of 16 columns and 40 rows. On recreating it as image i get scroll bars.

On recreating it as Excel and saving it in PDF format half of the columns come in first page and the next half in the second page. Not able to get the table in a single page. How to resolve this formatting issue. Any ideas?

Thanks,

Gokul

Re: How to get larger tables into PDF output format in Nprinting.

sujeetsingh — Fri, 17 Jun 2016 05:31:20 GMT

seems you need to accmodate your hardware.

Re: How to get larger tables into PDF output format in Nprinting.

avinashelite — Fri, 17 Jun 2016 05:39:07 GMT

Gokul, we cannot increase the page height rite. What is the problem if the data is shown in 2 sheets since we cannot fit the complete data in one slide is applying pagination in Excel . Imagine if your data gets increased to 100 rows then you cannot fit in 1 slide rite. I would suggest you to go with the current pagination approach.

Otherwise you need to adjust the chart size , test size then should try to fit in 1 slide

Re: How to get larger tables into PDF output format in Nprinting.

stig1984 — Thu, 19 Oct 2017 08:57:06 GMT

When you are importing the data into Excel in the NPrint designer have you tried setting the page width to 1 page instead of automatic? This can be found under the page layout tab and will then apply a zoom to force the table to fit one page wide - if it's a huge table it may not be readable though.

Re: How to get larger tables into PDF output format in Nprinting.

TPoismans — Tue, 25 Jan 2022 14:49:17 GMT

I know this might be seen as reviving a death topic, but for those people ending up on this page, just like me, your answer should've been marked as correct.

Column-wise, if you set the width of the page to "1 page", it'll fit the table to one page. Row wise, I don't recommend doing it, it would, more often than not, squish your table vertically when the # of rows start increasing.

Kind regards,
Tim P.

Re: How to get larger tables into PDF output format in Nprinting.

Ruggero_Piccoli — Tue, 25 Jan 2022 14:53:30 GMT

Hi,

If your goal is to create a report in PDF and you want to have a fine control of the layout the best solution is to develop a PixelPerfect template. Excel templates can generate reports in PDF but it is not the best tool to control the output layout, simply Excel is not designed for this.

Best Regards,

Ruggero