Limiting Number of records per page

Hi all,

i'm trying to limit the number of records per page.

I just followed the instructions given below.

1. Create the @Reset and @Details formulas:

@Reset - this formula goes into the Page Header. It resets the counter to 0 when SCR moves to a new page.

WhilePrintingRecords;
NumberVar counter := 0

@Details - this formula goes in the Details section. It counts each record.

WhilePrintingRecords;
NumberVar counter;
counter := counter + 1

2. Use the @Details formula to conditionally force a "New Page After". Every time the counter reaches the sixth record, it moves to a new page and prints the next set of six records.

Go to Format | Section, and select the Details section.
Click the "X+2" button beside the "New Page After" option (do NOT check the New Page After box). This opens the Condtional Formatting Formula Editor.
Enter the following condition:
{@Details} = 6
This formula forces a new page every time CR reaches the sixth record displayed on every page. The count resets to zero on every page because of the {@reset} formula in the Page Header.

The pbm is First page listing correctly (6 records) but rest of the pages showing more than 6 records.

Really struggling to solve. Any help will be appreciated.

Thank You and waiting for ur suggestions.!



Answer this question

Limiting Number of records per page

  • hungfut

    Hi ar_pad,

    Try declaring your counter variable as a Global in the @Reset formula:

    //@Reset

    WhilePrintingRecords;

    Global NumberVar counter := 0;

    This will make the counter variable accessable to all of your formulas.


  • dlypka

    I tried that, but it doesn't work as well...any other suggestions
  • lcubian

    Ohh i solved the problem, remove the reset formula that's on the page header and put it on the details section, both should be there,

    it worked for me !!!


  • Iago

    How do you create formulas on the crystal reports that's embedded to the .Net IDE 2003

    i can't find the way to create a formula at the Page Header Section.


  • Limiting Number of records per page