Page break at nth row in SSRS AX 2012.

SQL Server Rider

We can design a SSRS report with a constraint of only N rows per page. It will be interesting if I explain this with an example.

Scenario

Report developer get a request from team lead saying… Design a simple report with table component and display all rows available in a table x. But, you should show only 10 rows per page in the SSRS report. PS: I am expecting this report to be done with in 15 mins.

The brave report developer just design a report by pulling data to the report without our the 10 rows per page constraint.

I will be showing you that how to display only N rows in the report in this article.

Implementation

Design a report as described in the article. This implementation topic has page break configuration in the report.

Step 1: A simple design to show all rows in a table using table…

View original post 121 more words

Advertisements