Live Chat Icon For mobile
Live Chat Icon

How to Limit the Number of Rows Per Report Page

How to Limit the Number of Rows per Report Page

The number of rows and records displayed on a paginated report depends on the data fields used inside a table cell. Having various heights on each row will display a different number of records on a report page.

The SSRS RDL standard does not provide a straightforward way to control the number of records rendered on each page. But with our Bold Reports, you can limit the number of report page records using a simple dialog option. This blog will show you how!

Before we start, you can refer to this blog for how to create a table report with your data using Report Designer or download a previously created report from here.

We’ll go through the step-by-step process using the previously downloaded report. The following image shows the design of the sales report.

Sales report design view
Sales report design view

Set row limit to the table report item

1. Select the table report item and open the Properties panel.
2. Scroll the Properties panel and expand Miscellaneous.
3. Click Set Attributes to open the Custom Attributes dialog box.

Select the Set Attributes option in the Properties panel
Select the Set Attributes option in the Properties panel

4. Click Add in the Custom Attributes dialog.
5. Input Name as the RowsPerPage and set the desired row count in the Value field.

Add RowsPerPage custom property
Add RowsPerPage custom property

6. Here, we set the Value as 10 to display only 10 rows on each report page.

Note:
The property is ignored when the table row’s height is higher than the current report page’s available size. Increase the report height or reduce the RowsPerPage count to fit within the page.

7. Click Preview to see the output result in the Report Viewer.
8. Navigate to multiple pages and see how the report rendered displays only 10 rows on each page.

Renders the report pages with given record limit counts
Renders the report pages with given record limit counts

Conclusion

I hope this blog provided a clear idea on how to control the number of rows displayed on each report page using Bold Reports. To explore more, look through our demo samples and documentation site.

If you have any questions, please post them in the comments section. You can also contact us through our contact page or, if you already have an account, you can log in to ask your support question.

Bold Reports now offers a 15-day free trial without any credit card information required. We welcome you to start a free trial and experience Bold Reports for yourself. Try it and let us know what you think!

Catch us on our official Twitter, Facebook, LinkedIn, Pinterest, and Instagram pages for info about upcoming releases.

Leave a Reply

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.