Here's the solution I found on another site... worked perfectly for me.
Problem:
A typical situation is where a number of label copies must be printed for each order according to the {quantity} field in each order record.
Solution:
Create a REPEATER table with a single column (How_Many) that looks like this:
How_Many
1
2
3
4
5
6
etc.
Now, in your report, add the Repeater Table and add a join
condition of:
CODE
Order.quantity >= Repeater.How_Many
If the ">=" join option is not available, remove the join to the REPEATER table and create this condition in the Record Selection condition:
CODE
{Order.quantity} >= {Repeater.How_Many}
If you are restricted to using an equal join, you can also modify the repeater table to include N records for each quantity N:
1
2
2
3
3
3
...
This would cause each order to be duplicated as many times as the value of {Order.quantity}.