I'm setting up a report in Crystal Reports that generates product labels based on information pulled from a Part Order in a database. I want the report to generate the number of labels for each part in accordance with the quantity for each part. While many people try to remove duplicates, I would like to create a duplicate of each label depending on the value of the quantity field.
I currently have each label in separate detail sections with no groups of any kind. There are 10 on a page, with 2 columns of five so they fit standard Avery labels. Any help would be greatly appreciated, thanks!
duplicate your query with UNION between them.