Limit the Number of Records per Page

The number of records shown in a report can be limited by means of conditional formatting. In particular, a formatting rule is applied to the Visible property of the Page Break control. In this example, the number of data rows is passed to the report as a parameter.

To limit the number of records per page

1. Create a new report or open an existing one. In this example, a data-aware table report is used as a starting point.

   

2. To add a parameter to the report, in the Field List, right-click the Parameters section, and in the dropdown menu, choose Add Parameter.

   

3. Set the (Name) property of the parameter to rowsNumber, the Parameter Type parameter to Int32 and the Description property to Rows per Page:.

   

4. Drag the Page Break control from the Toolbox onto the report's Detail band and place it at the top of the detail table.

   

5. For the created control, set the Visible property to No, and for its Formatting Rules property, click the ellipsis to display the Formatting Rules Editor.

   

6. In this window, click Edit Rule Sheet. The Formatting Rule Sheet Editor is then displayed.

7. Click , to create a new formatting rule. Set its Visible property to Yes, and for the Condition property, click the ellipsis, to display the Condition Editor.

   

8. In this editor, define the following expression for the rule: ([DataSource.CurrentRowIndex] % [Parameters.rowsNumber] == 0) And ([DataSource.CurrentRowIndex] != 0).

   

9. Click OK to save the changes and close the window.

10. Then click Close to close the Formatting Rule Sheet Editor.

11. In the Formatting Rules Editor, the created rule is displayed.

12. Move it to the list of applied rules on the right, use the > button.

    

13. To close the editor, click OK.

    The report is now complete.

14. Switch to the Preview tab, and in the Parameters section, define the required and then click Submit.