Force New Page

[Bennie47250]

Using Crystal 7.0

Is there a way to force a new page after 32 rows of data have been printed to a page?

Thanks
Bennie

 

[kray4660]

Probably, but I do not have CR 7. Do a formula modulus of 32 (PageNumber mod 32)on the record count (in the New Page After of the detail section expert (Report, Section Expert, Click on Details, Paging). I am now using CR 2011, so I am hoping that this was available in CR7.

 

[AndyMc]

I tried what kray4660 suggested and this worked:

Go to section expert of the detail section and click on the formula icon next to 'New Page After' and
enter: RecordNumber mod 32 = 0

 

[Bennie47250]

Thanks you 2. Version 7 does not have these options but perhaps I can find a similar way in 7.

 

[AndyMc]

You can get a similar result by subtracting the division of 32 from the integer division of 32:

Try (notice the difference in the division signs): (recordnumber / 32) - (RecordNumber \ 32) = 0

 

[AndyMc]

Probably a more elegant way of writing the formula:

recordnumber / 32 = RecordNumber \ 32