IIJ Tech Support
Top achievements
Rank 1
Rank 1
IIJ Tech Support
asked on 09 Mar 2011, 06:30 PM
I was wondering if there was a way to have the details area repeat based on a data value.
The exact circumstances are these:
I have a table of items ordered (Order_Details) with the columns (OrderDetailID, ProductID, Quantity, etc)
I have a second table with the product information (Products) with columns (ProductID, ProductName, Barcode, etc.)
What i am trying to do is create a report with the barcodes for all the items sold. The catch is, i need the details area of the report to print once for each Quantity rather than once for each record.
E.g. if i have product #1 quantity 4, the barcode for product #1 should print 4 times, rather than once.
Is there a setting or option i'm missing, or am i going to have to do SQL magic for this one?
Thanks!
P.S. Your barcode control is fantastic!
The exact circumstances are these:
I have a table of items ordered (Order_Details) with the columns (OrderDetailID, ProductID, Quantity, etc)
I have a second table with the product information (Products) with columns (ProductID, ProductName, Barcode, etc.)
What i am trying to do is create a report with the barcodes for all the items sold. The catch is, i need the details area of the report to print once for each Quantity rather than once for each record.
E.g. if i have product #1 quantity 4, the barcode for product #1 should print 4 times, rather than once.
Is there a setting or option i'm missing, or am i going to have to do SQL magic for this one?
Thanks!
P.S. Your barcode control is fantastic!