I am trying to build a report that produces a number of Pallet Labels (one per page), based on a total qty, though that is a bit of a vague description. To be clear…
my SQL query returns 1 record with a total qty - e.g. 7.5 tonnes
my report then needs to print 7 pages, each with a label that specifies a single full pallet of 1 tonne, and then an 8th label for the remaining 0.5 tonne ‘part’ pallet.
I have the basic label layout defined as a Page Header and a Page Footer, but I can’t figure out how to keep printing multiple pages based on a single record returned from the database. My programming background tells me I need to have a counter that I set to 7.5 and then just keep decrementing it until it gets to zero, printing a page each time based on the qty outstanding, but I am guessing that the workflow of Crystal doesn’t allow me to loop iteratively like that - so does anyone know any alternative mechanism to achieve this?
I’m using SAP Crystal Reports 2013 SP6
Thanks
Graham
smithg22 (BOB member since 2018-12-19)
(BOB member since 2007-07-04)