Jump to content

Recommended Posts

Posted

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?
  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...