Do you have a max quantity number?  The one way I can think of to do this will only work if that max quantity is not too large.

1.  Create as many detail sections as the max quantity number.

Ok, here is another idea for getting Crystal Reports to print multiple mailing labels (but only if you have control over your database). Create a SQL table, Labels, with just one field (LabelNumber) and create as many rows as you need for the max number of labels (say 1 to 100) with the values being sequential. Then do a SQL statement that joins the new table to your existing table and use the LabelNumber field as the linking field. You have to do something similar to the following:

select * from DataTable
join Labels
on Labels.LabelNumber<=DataTable.NumToPrint

What this does is create a resultset that has multiple records joined to the Labels table for each record that has a value less than or equal to the number of labels to print (did that make any sense?) It effectively duplicates each row from DataTable as many times as necessary based upon the NumberToPrint field (or whatever yours is called). Anyway, if you can make sense of the SQL statement and use the correct fields, this should do the trick for you.


Edited by BrianBischof - 01 Feb 2007 at 4:12pm