topic Re: How to report a table using multiple pages in PDF (CreateReport function) in Qlik Automate

How to report a table using multiple pages in PDF (CreateReport function)

Paulo_IntelFab — Thu, 08 Aug 2024 15:18:07 GMT

Hello,
I have to create a report with long tables (more than a page is needed is needed to show the entire table) using Qlik Cloud.
Now my report works well, the only problem is that the tables are cut and doesn't show all the data on table.

I appreciate any help.

Re: How to report a table using multiple pages in PDF (CreateReport function)

igoralcantara — Thu, 08 Aug 2024 15:28:25 GMT

There is an ugly workaround which is make a long table in the Qlik UI. Other than that, I recommend using the "new" tabular reporting feature.

I presented a Happy Hour webinar about this a while ago. You can watch here:

Webinar & Happy Hour: "Move Over NPrinting, and Hello Qlik Cloud Reporting Services!" (ipc-global.com)

Re: How to report a table using multiple pages in PDF (CreateReport function)

Paulo_IntelFab — Thu, 08 Aug 2024 18:20:35 GMT

Thanks a lot!
I'll put on practice now.

Re: How to report a table using multiple pages in PDF (CreateReport function)

Paulo_IntelFab — Wed, 14 Aug 2024 19:34:22 GMT

Hi, @igoralcantara! I learned a lot watching the webinar. Congratulations and Saúde!!

After some troubleshooting installing the Qlik Add-In (which by the way, only works for me in the web), I started to design the report. I have a table with 12 columns and it`s been displayed in 2 different pages in PDF (using the Qlik add-in preview as PDF).

Questions:
1) there's a way to define where the page breaks on the report using the Excel Web?
2) the desktop Excel is supposed to allow this page breaks?
3) Any suggestion to put a 12 columns table on a single page?

Once more, thanks for helping!

Re: How to report a table using multiple pages in PDF (CreateReport function)

igoralcantara — Wed, 14 Aug 2024 20:02:18 GMT

Thanks, @Paulo_IntelFab ! I am glad I could help.

All of these things you have to do in Excel. Go to the View menu and enable the page limit options to see the page size, adjust column sizes and such. You have to adjust these items in the Excel, there is no Qlik property needed. This is the beaulty of the Excel template.

Re: How to report a table using multiple pages in PDF (CreateReport function)

Paulo_IntelFab — Mon, 19 Aug 2024 13:46:11 GMT

I've just solved the desktop Excel add-in fail using the steps described in the article Deploying and Installing Qlik add-in for Excel.

It worked both for Mac and Win10 / Win11.