Page Break In SSRS Report

Page Break In SSRS Report

Trainee: Song Thanh Nghia

Today my member of team trainee sent me a blog to create a SSRS Report and how to break page in report.

I really know it, but so long time no interactive(tương tác) with AX 2012 So that note it in my blog

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.

The brave(thách đố)  report developer just design a report by pulling (kéo)  data to the report without our the 10 rows per page constraint(hạn chế).

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

Step 2: Add a group to the detail row

Step 3: Add group expression “=Ceiling((RowNumber(Nothing)) / Nth row)” and Click OK

Step 4: You may get the following error if you run the report after step 3.

Step 5: Open Row group properties and remove sort expression.

Step 6: Now, report will show 30 rows in a group. Next step is to define page break for the group. Go to page breaks tab and select page break option

Step 7: Now, hide the group header and detail column from the table component and run the report.

Thanks for reading. Please subscribe for e-mail for instant article delivery to your inbox. For latest updates vision Facebook page SQLServerRider.com and like the page.