Tuesday, July 15, 2008


I recently wrote a report that required only 7 records per page. While researching the best way to execute this, I found the following tip on the Seagate Software web site. The support section of the Seagate Software web site is an excellent source for Crystal technical information and tips. This web site is an invaluable resource for anyone using Crystal Reports.

To limit the number of records per page, you need to create two formulas that create a running total for each page.

1st Formula: HeaderReset - This formula should be placed in the page header of the report. It will reset the counter when the report is processed to the next page. Counter is a variable that stores the number as the report processes each record.

NumberVar counter:=0

2nd Formula: CountDetails - This formula should be placed in the Details section. It will count each record and increment by one.

NumberVar counter;

You will now need to use the CountDetails formula to force the new page based on the necessary number of records. To do this:
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:
(enter the number of records you need on each page)

This condition will force a new page when Crystal reaches the seventh record in the details section. The count will reset to zero at the beginning of each page due to the @HeaderReset formula.

If you need to count the Group Header records instead of the Details section, follow the above instructions for the details section, but place the formula and condition in the Group Header section instead of the Details section.

To hide the formula fields in the header and details section, right click on the field and go to format font. Change the color to white and you will not be able to see them.

*NOTE: These instructions presume that you have a working knowledge of Crystal Reports. Accuvar assumes no responsibility for any data loss or downtime caused by performing this tip.


Post a Comment

Popular Posts