Friday 21 April 2017

Restrict no Of Reports per Page

Limit the number of records per page in crystal reports: 

1 : 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

2 : Use the Count Details formula to force the new page based on the necessary number of records.

3: 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

No comments:

Post a Comment

Control Structures (Crystal Syntax) In Crystal Report : If Expressions (Crystal Syntax) in Crystal Report

Formulas without control structures execute each expression in the formula exactly once when the formula is evaluated. The expressions are...