Your best option is to get the barcode software Bartender, the Enterprise edition.  It can do that. 

Your best option is to get the barcode software Bartender, the Enterprise edition.  It can do that. 

That's an expensive solution. Is there another way?

I have done this before with a Crystal Reports file.  I'll try to find the solution and post it.

We've done this with a dummy sequence table, outer join, and creative custom Crystal Reports design (with a report selection criteria formula to control the quantities per item).

That would be great. Thank you.

I have never done anything like that in the past. How is this done? Thanks

The Seagull Scientific BT-EA3 Bartender Enterprise Automation can be found for as low at $570.00. With one client wrote a simple script and put it on a button on the menu bar so they could print out the labels by clicking the button.  Yes you can do it with Crystal but it ain't easy.

Set up a UDT with a single column and add values 1,2,3,4... up to the maximum number of labels you'd need.  Then in the .rpt set up an open link from your label data to this sequence table (link with an =! on unrelated data, so there is no filter), and use a report selection formula so that the sequence table value is <= your item quantity.  This should repeat each line the correct number of times, so then you just need to do the label design.

Create a UDT (User Defined Table) with incremental values, starting with 1.  For example, the first record has a field equal to 1, and the next record has a field equal to 2, etc.

Link CI_Item or whatever table you're using to the UDF.  Change the Link Type to "!=" in the Crystal file - Database Experts - Links tab.

Create a record selection formula, using similar logic as follows:

{@number of labels} <= {?number of labels} and
{CI_Item.ItemCode} = {?item #}

In my example, I have two parameters:

1 - item code

2 - number of labels to print (number parameter type)

With the "number of labels" parameter, the user can decide how many labels to print per item selected.

You can create variations of this report, using the S/O detail and P/O detail qty ordered or qty received fields.  Just change your record selection formula to the field you're using instead of the number of labels parameter.

I ended up finding a solution similar to the one you supplied online. I created a UDT and I am up and running. However, I want to note some things for future reference.

1. I was running the ‘Inventory Label Printing’ option from the IM Reports Menu. We wanted to select all Inventory Items and print labels only for the items that have an On-Hand Quantity.
2. The 'Inventory Label Printing' option uses a WRK file (IM_InventoryLabelsWRK). The WRK file did not include the QTY on Hand so I had to link the WRK to the CI_Item file, and I had to link the CI_Item file to the UDT. When I tried to link the ‘TotalQuantityOnHand’ field from the CI_Item table to the UDF in the UDT table they would not link together because the UDF is a string format where the ‘TotalQuantityOnHand’ is numeric. So, I created a numeric UDF for the UDT. I then linked the two together using a left outer join and the >= Link Type.
3. When I printed the labels two things happened.
   1. The Item Numbers that did not have a ‘TotalQuantityOnHand’ value printed a single label for all items (Preview mode of course). I simply created a record selection formula to include items with greater than 0 QTY.
   2. The item numbers that did have a ‘TotalQuantityOnHand’ printed the labels twice. To get around this, I set the ‘Number of Labels Per Item’ in the entry screen to 0.

After doing all of this, the labels are printing correctly.

Thank you all for your help.