How to limit Crystal Report Records ?

[maqmaq]

Hi
I would like to know ho can I limit the number of records to be printed in each page, for example I want 5 records to be printed only instead of printing till the end of page margin...Any help will be appriciated..
Thanks

[Bigley]

You could put a formula in the 'New Page After' property of the details section that checked a record number(if you returned a record number along with the record) to see if it was divisible by 5.
It's a bit of a hack but that's crystal for you or I should say that's crystal for me.

[maqmaq]

Would you please explain how to do that, I right click on the details section and select format section then click on the new page after, what will be next ??
Please help..
Thanks

[Bigley]

If you have a record number returned with the recordset then in the formula write something like this

If Remainder({tabl.recordnum}, 5) = 0 Then
true
Else
false

hope this helps