I want SSRS reports to have 20 rows of data per Page

Question

Hi experts,

I have a report and I want to have 20 rows of data per page. What should I do?

Thanks for any suggestions.

Answer 1

Hi @Jasperalexander

You can use the Ceiling function.

You can add a grouping to your report by entering "=Ceiling(RowNumber(Nothing)/20" in the grouping expression. Then tick "Between each instance of a group" in Page Breaks of the group properties. Note that you want to delete the expression that is automatically generated in sorting, otherwise it cannot be run. If you don't want to display groups, you can choose to remove only columns.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Answer 2

To display 20 rows of data per page in your SSRS report, you can follow these steps:

1. Open your report in SQL Server Data Tools (SSDT) or Report Builder.
2. In the Report Data tab, locate the table or matrix that contains the data you want to display.
3. Right-click on the table or matrix and select Properties.
4. In the Properties window, go to the Paginate tab.
5. Under Pagination, select the checkbox for "Enable paging."
6. Set the value for "Data region rows per page" to 20.
7. Optionally, you can also set the value for "Data region columns per page" to adjust the number of columns displayed per page.
8. Click OK to save the changes.

Now when you run the report, it will display 20 rows of data per page, with pagination controls to navigate between pages if needed.

Hope it helps!