Technical Articles
How to Create a Paginated Report in SAP Analytics Cloud?
A paginated report is designed to be printed and formatted to fit pixel-perfectly on the A4 page. This report displays whole data in a table although the table expands in multiple pages. In this blog I am going to explain how to create a paginated report in SAP Analytics Cloud (SAC).
Below are the steps being used to create a paginated report in SAC:
Step-1: Create a new story with canvas page.
Step-2: Add a table to the story canvas.
Step-3: Select the model.
Step-4: Go to styling of the page.
Step-5: Select page size as fixed.
Step-6: Select size as A4 as well as select the orientation.
Step-7: Select the table and go to the builder. Choose the rows and columns and check “Auto-size And Page Table Vertically”.
Step-8: Go to styling of the table and select the appropriate template.
Step-10: Export the report as a pdf.
In this way we can create a paginated report in SAC.
Conclusion: Paginated report is the very strong feature of SAP Analytics Cloud as a reporting tool where we can design a pixel-perfect report as per printing requirement.
Hi Suvam,
Thanks for your contribution! This is a nice and comprehensive blog on how to create a paginated report. I was just wondering; is there also an option to just select a table from an existing story created in responsive layout and export that table in a paginated manner? It's a pity that the page/layout settings as part of the initial story setup instead of truly being part of the 'export story as' options. Any thoughts?
Kind regards,
Martijn van Foeken | Interdobs
Hi Martijn, Paginated report is only possible with canvas page as of now. And selected single table can only be exported as either excel or csv format.
Hi Suvam,
So that means we have some improvements to go ;-). Thanks again for your blog and reply!
Kind regards,
Martijn van Foeken | Interdobs