How to Create a Paginated Report in SAP Analytics Cloud?

[suvamdey17]

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-9: Go to view of the report.

 

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.

[mfoeken]

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

[suvamdey17]

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.

[mfoeken]

Hi Suvam,

So that means we have some improvements to go ;-). Thanks again for your blog and reply!

Kind regards,

Martijn van Foeken | Interdobs

[juan_conesa]

Any expectation for having horizontal pagination?. (like in excel?). Having reports with many columns is common and it is not solved.Only vertical pagination is solved.

[s_schneemann1]

Hi @suvamdey17 ,

is it possible to show the "page" number in the exported pdf when using pagination? I have tried different things, but was not able to show page numbers in the footer of the report (we use the reporting layout and DinA4 layout).