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

[Paulo_IntelFab]

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.  

[igoralcantara · Accepted solution]

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.co...

[Paulo_IntelFab]

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

[Paulo_IntelFab]

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! 

[igoralcantara]

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.

[Paulo_IntelFab]

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.