none
Number of rows set per page in SSRS2008

Answers

  • 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

    Wednesday, January 01, 2014 7:10 AM

All replies

  • It depends on the report layout.

    Ione

    Tuesday, December 31, 2013 7:33 PM
  • 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

    Wednesday, January 01, 2014 7:10 AM