In this article I will explain how to set or limit Number of Records per page i.e. PageSize when doing paging in Crystal Reports.
Crystal Reports Paging: Set (Limit) Number of Records per page
In order to set or limit Number of Records per page i.e. PageSize when doing paging in Crystal Reports, you will need to do as shown in the following steps.
1. Open Crystal Reports in Design View and right click on the Details Section and then select Section Expert option from the context menu.
![Crystal Reports Paging: Set (Limit) Number of Records per page]()
2. Inside the Section Expert Dialog, select Paging Tab and then check the New Page Before CheckBox. Now click on the Formula Button next to the New Page Before CheckBox.
![Crystal Reports Paging: Set (Limit) Number of Records per page]()
3. Inside the Formula Editor Window, you will need to write a formula as shown below.
![Crystal Reports Paging: Set (Limit) Number of Records per page]()
Formula Syntax
IF Remainder (RecordNumber, {RecordsPerPage}) = 0 THEN
TRUE
ELSE
FALSE
Example
In the following formula, I have set the records per page value to 8. This will force Crystal Report to display maximum 8 records per page.
IF Remainder (RecordNumber, 8) = 0 THEN
TRUE
ELSE
FALSE
Finally click Save and close button to save the formula.
