Limit the Number of Records per Page
This document describes how to specify the number of data source records displayed on report pages.
Warning
Use the approach below if expression bindings are not enabled in the Report Designer (the Designer does not provide the Expressions panel).
See Limit the Number of Records per Page if expression bindings are enabled in the Report Designer (the Designer provides the Expressions panel).
After you bound your report to data and provided content to the report's Detail band, you can limit the number of records each report page displays. This example demonstrates how to pass the required record count as a parameter value.
Switch to the Field List panel, select the Parameters node and click Add parameter to add a new report parameter.
Specify the parameter's description displayed in Print Preview and set its type to Number (Integer).
Drop a Page Break control onto the report's Detail band and disable the control's Visible property.
Expand the Appearance node, select the Formatting rules and click the plus button to add a new formatting rule.
Expand the Formatting node and set the Visible property to Yes. Click the Condition property's ellipsis button. In the invoked Expression Editor, specify the required visibility condition.
For example:
([DataSource.CurrentRowIndex] % [Parameters.parameter1] == 0) And ([DataSource.CurrentRowIndex] !=0)
Click OK, to save the changes and close the dialog.
Enable the formatting rule's check box to apply the created formatting rule to the control.
When switching to Print Preview, you can specify how many rows each report page should display by entering the corresponding parameter value: