How to repeat details or subreport 'x times

[tdol_1]

I need the ability to print multiple shipping labels based on a query that returns a single record.  The record contains the number of labels I need to print but I cannot figure out a way to print.  For Example, if the number of labels is 5, I need to print 5 labels but the labels need to show... Box 1 of 5, Box 2 of 5, Box 3 of 5 and so on....  I can only get 1 label to print because the query result is 1 row.

I've tried this code in my report query, which returns 10 rows in SQL Server Manager Studio, but only 1 row in iReport.

DECLARE @cnt INT = 0

while @cnt < 10

begin

   SELECT * FROM sa_pack_detail_pkg WHERE packd_id = '760EA323-FC47-49AC-B60F-42297F3A1F29'

 set @cnt = @cnt + 1

end 

 

 

Any ideas how I can do this in iReport?