Limit the Number of Records per Page

Limits the number of records displayed in a report using conditional formatting. A formatting rule is applied to the Visible property of the Page Break.

In the example, the number of visible data rows is defined as a parameter.

1. Create a new report

2. Bind the report to a data source.

3. On the Field List window, click the Field List tab and select Parameters.

4. Right-click and select Add Parameter from the drop-down menu.

   

5. On the Add New Parameter window, set the Name to rowsNumber.

6. Set the Description to Rows per Page:.

7. Set the Type to Number (32 bit integer).

   

8. On the Toolbox, select Page Break.

   

9. Within the Detail band, click the top of the report blank space to position the control above the report data.

   

10. On the Properties window, click the Behavior tab.

    

11. Deselect the Visible check box.

12. On the Properties window, click the Appearance tab.

13. Click the ellipsis next to Formatting Rules to display the Formatting Rules Editor window.

    

14. Click Edit Rule Sheet to display the Formatting Rule Sheet Editor window.

    

15. Click Add a formatting rule to create the new rule and define the rule properties.

16. Set Visible to Yes.

17. Click the ellipsis next to Condition to display the Condition Editor window.

    

18. Define the Boolean condition ([DataSource.CurrentRowIndex] % [Parameters.rowsNumber] == 0) And ([DataSource.CurrentRowIndex] != 0).

19. Click OK to save the condition and close the Condition Editor window.

20. Click Close to save the formatting rule and close the Formatting Rule Sheet Editor window.

21. Use the arrow buttons to move the currently selected rule in the Rules available in a report list to the Rules applied to a control list.

    Note:
    Multiple formatting rules can be applied. Rules are applied in the order that they display in the list, the last rule in the list has the highest priority. Use the up and down buttons to modify the rules priority.

22. Click OK to apply the formatting rules and close the Formatting Rules Editor window.

23. Click the Print Preview tab to display a preview of the current report layout. The Parameters window displays which must be populated before the preview can be completed.

    

Refer to Create Layout Template / Report Definition and Bind Report to Dabacon Project Data for further information.