Print multiple labels based on quantity value

[Former Member]

Hi,

I'm looking to print out bar code labels at the point in which we ship the product. My problem is this:

1.) We have an order with 2 Line Items.

2.) The first line item has a quantity of 4

3.) The second line item has a quanitity of 10.

4.) I need to print out 4 bar code labels for item 1 and 10 bar code labels for item 2.

I don't know how to accomplish this. I've got the report working fine but it only prints one label per line - any and all help is appreciated.

[Former Member]

is there a maximum

lets say it's 20

then

if the data table is FRED change to command

select fred.*,counter from fred

cross join ( select 1

[Former Member]

is there a maximum

lets say it's 20

then

if the data table is FRED change to command

select fred.*,counter from fred

inner join ( select 1 as counter union all select 2 as counter .... up to 20)

on counter < fred.quantity