This is a migrated thread and some comments may be shown as answers.

Repeat Details area based on data value

0 Answers 75 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
IIJ Tech Support
Top achievements
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!

No answers yet. Maybe you can help?

Tags
General Discussions
Asked by
IIJ Tech Support
Top achievements
Rank 1
Share this question
or