Variable number of reports.

[spoole]

I have some data I would like to go into a report e.g

OrderNumber: 123456

QtyOrdered: 10000

We process orders in sets of 3000 so for the above data I would require 4 reports. 3 reports will be for 3000 and the remaining 1000 on the 4th report.

So far I have tried with no success, anyone got any ideas?

Cheers Steve.

 

[khawar]

you can creat a loop statement for opening same report with ranged records
or
you can use a select statement to divide records in category of 3000 each and then force new page at end of each group

 

[spoole]

thanks Kahwar I will look into that.