Reporting
User Guide
Create Reports : Miscellaneous : 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 add a parameter to the report, in the Field List, right-click the Parameters section, and in the dropdown menu, choose Add Parameter.
|
|
•
|
Set the (Name) property of the parameter to rowsNumber, the Parameter Type parameter to Int32 and the Description property to Rows per Page:.
|
|
•
|
Drag the Page Break control from the Toolbox onto the report's Detail band and place it at the top of the detail table.
|
|
•
|
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.
|
|
•
|
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. |
|
•
|
In this editor, define the following expression for the rule: ([DataSource.CurrentRowIndex] % [Parameters.rowsNumber] == 0) And ([DataSource.CurrentRowIndex] != 0).
|
Click OK to save the changes and close the window. Then click Close to close the Formatting Rule Sheet Editor.
|
•
|
In the Formatting Rules Editor, the created rule is displayed. Move it to the list of applied rules on the right, use the > button.
|
The report is now complete. Switch to the Preview tab, and in the Parameters section, define the required and then click Submit.
