force page break after certain number of lines

[staceyn]

Hello,
I am working on a report where I need the report to page break after 20 lines from the group header 1. The client uses pre printed forms and on longer orders the data is running into the preprinted data on the printed form. The number of lines on any given order can vary from 1 to about 50 or so.
So just trying to figure out how to force a page break after so many records are printed from group header1.
I tried using section expert, paging, new page after using formula where recordnumber is = 20, but am now only getting 3-5 lines per page so that doesn't appear to be working.
THere is only 1 group on the report, but ther is a group 1a,1b, 1c and 1d.

Thanks for any assistance you can provide.

 

[pmax9999]

You could use a running total, reset on change of Group 1, that counts one of the fields on the report.

Then, use the following formula to set the New Page After:

Remainder({#RT-Count},20) = 0

(where {#RT-Count} is the running total)

Hope this helps.

Cheers
Pete