Number of rows set per page in SSRS2008

Hello,

If I understand correctly, you want add page break in the report based on the row number. In SSRS 2008, we can use group page break to work around the issue.

Please refer to the following steps:

1. Add a table in report body, add several fields in the report.


2. Right click “(Details)” in the Row Groups dialog box, select Add Group -> Parent Group (Group1) with following expression:
   
   =Ceiling(RowNumber(Nothing)/5)


3. Right click Group1 in the Row Groups, select Group Properties.


4. Click Page Breaks in the left pane. Select “Between each instance of a group” option.


5. Click Sorting, then delete the sort which is based on Group1.

If you have any questions, please feel free to ask.

Regards,

Alisa Tang

---

Alisa Tang

TechNet Community Support