LIMITING
THE NUMBER OF RECORDS PER PAGE ON A CRYSTAL REPORT
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.
WhilePrintingRecords;
NumberVar counter:=0
2nd Formula:
CountDetails - This formula should be placed in the Details section.
It will count each record and increment by one.
WhilePrintingRecords;
NumberVar counter;
counter:=counter+1
You will now need to use
the CountDetails formula to force the new page based on the necessary
number of records. To do this:
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.
