In SQL Server Reporting Services you can add a page break after a desired amount of records. Here is how you do it.
1. Add a new Row Group and give it a name.
In our example we named our group:
2. Go to the properties of the Row Group.
3. Use the following expression to group the row on:
=Floor((RowNumber(Nothing) – 1) / 250)
In this example, 250 is the number of records we want per page.
4. On the Page Breaks tab, check the following:
‘Between each instance of a group’
‘Also at the end of a group’
Go ahead and run the report.
You should now have 250 records per page.