how to insert page break after certain no. of records?

[yehong]

I want to insert a page break after 7 records. That means if there are 15 records, the report should show 7 records on first page, 7 on second page and 1 on third page.
Thanks for any idea or tips.

 

[vidru]

Try this formula:

Remainder(RecordNumber, 7) = 0
And
Not (OnLastRecord)

-dave

 

[yehong]

Dave, where and how should I add this formula? When I add this in a formula and place it on the same detail line, it returns true on 7th record only i-e, it is false from 1-6th, true on 7th then again false from 8-13th and true on 14th.

 

[vidru]

Sorry, should have clarified that...

You want to invoke the Section Expert (Format>Section), highlight your Details section, click the [x+2] button next to 'New Page After', and paste the formula there.

-dave

 

[CrystalReports9]

I am forcing the page break in the <DETAIL> section (only 8 lines). The problm is like the remaining sections like <GF><RF><PF> will not get diplayed in BOTH Pages (before page break page, after page break page) ?

How 2 make it to display the <GF><RF><PF> in both pages ?