Search code examples
crystal-reports

Fixed number of results per page

How can I limit the number of results that populate in the Details section to a fixed number per page?

Solution

  • To do this, configure the Details section to force a page break every ten records.

    1. Put a suppressed running total called RecordCount in the Details section. Make it increment every time a record is printed.
    2. Create a formula called CountPerPage and set its value to 10. (Or make it a parameter if you want the user to be able to choose how many records per page.)
    3. Set the Detail's New Page After to (#RecordCount} Mod {@CountPerPage} = 0