BOFocus – Crystal Reports Tips – Tricks – Tutorials

Crystal Reports - Formulas

Limit the number of records per page

Create the following formula and place in the page header:

WhilePrintingRecords;
NumberVar counter := 0

Create the following formula and place in the detail section:

WhilePrintingRecords;
NumberVar counter;
counter := counter + 1

Use the CountDetails formula to force the new page based on the necessary number of records.

Go to Format/Section and select the Details section.

Click on the X+2 button to the right of the “New Page After” option. Be sure not to place a check in the New Page After box. Once you click on the button, you will be placed in the formula editor. Enter the following formula:

{@CountDetails} = 10 //Enter the number of recorders that you will want displayed on each page

Tagged , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

GET SOCIAL

QUICK TIP

A formula that is placed on a report is indicated by the @ prefix (for instance, @Name).

ADVERTISMENT