Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
95% of our time seems to be focused upon the problems, and only 5% on finding solutions
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

06
June

How Do I Control the No. Records Per Page in Crystal Reports 2008?

I was recently asked "How do I control the number of records printed per page to 50 in Crystal Reports 2008?"

Solution:

The solution is to create three formulas:
  1.     Counts the number of records on the page
  2.     Resets the counter, from page to page, and
  3.     Forces the new page break, once the required No. records has been reached.

  1. Create the Reset Counter formula, using the following:

  2. WhilePrintingRecords;
    NumberVar counter := 0

  3. Add the {@Reset Counter} formula field to the Page Header section

  4. Select the {@Reset Counter} formula field and suppress

  5. Create the Record Counter formula, using the following:

  6. WhilePrintingRecords;
    NumberVar counter := counter + 1

  7.  Add the {@Record Counter} formula field to the Details section

  8. Select the {@Record Counter} formula field and suppress

  9. From the Report Menu select the Section Expert option

  10. In the Section Expert dialog box, select the Details section

  11. Press the Conditional Format button [x+2] for the New Page After option

  12. Enter the following formula:

  13. {@Record Counter}=50

  14. Press the Save and Close button


If you have any questions, or need any assistance, please do not hesitate to
Contact Us

1

klausen

24
October
working!
2

Sabna

09
May
Thank you for your valuable info.Its working for me. But problem is that If I have 18 records to print,So I set 15 records per page.So first 15 records print on first page and remaining 3 records prints on sec page.And my Report footer portion print next to details.I also need 12 blank rows to be added .How can I add this.
3

Julia

02
August
Hi Sabna Simply apply section formatting to the Report Footer section to print at the bottom of the page.
4

SAMUEL

13
October
PLEASE I HAVE TERMS AND CONDITIONS, AND I WANT MY COMMENT FIELD TO DISPLAY EVERYTHING, AND I WANT IT TO APPEAR ON THE SECOND PAGE OF THE CRYSTAL REPORT.. PLEASE HOW TO I GO ABOUT IT

MAKE A COMMENT

Name *

Email Address *

Comment *