This tutorial demonstrates how to define how many records should be displayed at each page in a report's Print Preview. Note that no scripts are required to accomplish this task.
To demonstrate this feature, we'll use a report, similar to the one created in the following tutorial: Change or Apply Data Grouping to a Report.
To limit the number of records per page, do the following.
-
To add a parameter to the report, in the Field List, right-click the Parameters section, and in the invoked menu, choose Add Parameter.
-
Select the parameter, and in the Property Grid, set its Description to Rows per Page:, Parameter Type to Int32 and (Name) to rowsNumber.
-
From the Toolbox, drop the Page Break control onto the top of the report's Detail band.
-
Select the Page Break, and set its Visible property to No. Then, click the ellipsis button for its Formatting Rules property, and in the invoked Formatting Rules Editor, click the Edit Rule Sheet... button.
-
Now, in the invoked Formatting Rule Sheet Editor, click , to create a new formatting rule. Set its Visible property to Yes, and click the ellipsis button for its Condition property.
-
In the invoked Condition Editor, define a logical expression for the rule, (e.g. ([DataSource.CurrentRowIndex] % [Parameters.rowsNumber] == 0) And ([DataSource.CurrentRowIndex] != 0)).
To save the changes and close the dialog, click OK.
Then, click Close, to quit the Formatting Rule Sheet Editor, as well.
-
Now, back in the Formatting Rules Editor, move the created rule to the list of applied rules on the right, using the arrow buttons in the middle of the dialog.
To save the changes and close the editor, click OK.
The report is now ready. Switch to the Preview Tab, and in the Parameters section, define the required value and click Submit.
Note that while in this example, the number of rows is specified each time the report is being previewed, you can make this number secure, by setting the parameter's Value option to the desired value, and then setting the report's Request Parameters option to No.