How to set the maximum records shown in a page to be 25?

[Devaki]

Hi,
I am using Crystal 8.5. I want each page to show only 25 records how do i do this. I tried to do the following
In the Section Expert the selected new page after for the details and gave the condition as recordnumber=25 but this sets only if the recordnumber is equal to 25. Again my second page has more than 25 records. If i specify recordnumber/25=0 then also it doesn't work. How do i do this? Please help.

Thanks
Devaki

 

[Roadkill150]

Hello,
Right click on the detail in the margin, select the format section, press the formula button to the right of "new page after" enter the following formula: recordnumber>25
this will make the details go to a new page once the number of details on a page hits 25
cheers,
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[IdoMillet]

Assuming you have more than 2 pages in your report,
the technique described by Bruce would have to be modified
by using a variable (reset in page footer, increment in detail section).

Cheers,
- Ido ixm7@psu.edu

 

[Roadkill150]

Heh.. whoops forgot that.. yes you need a reset in the page footer. you can do it with a count that resets on each new page.. good catch Ido!
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[stevesd]

Go to thread # 149-227953 It works great!

 

[Devaki]

Hi,
I created something like this in the detail section and got the count but how do i reset the value at the page footer could you please explain in detail


WhilePrintingRecords;
numberVar Test1;
Test1:=Test1+1

thanks for your help
Devaki

 

[IdoMillet]

Just create a formula such as:

WhilePrintingRecords;
Test1:=0

and place it in the page footer.

Cheers,
- Ido


ixm7@psu.edu