Printing multiple labels

[twes3]

Question:
I have a crystal report where I setup to print a label 5 across. My problem is I need to print (x) amount of the label based on a formula where I add two database fields. For example, InvOnHand = 5, InvOnOrd = 5 --total of 10
I would have to print this label 10 times. This report is not just for a single record, it contains multiple records, so each record would print according to the formula where I add those two fields. Does anyone have any suggestions?

Thanks in advance....

 

[VBrit]

Bind the report to a stored procedure, and sort out your records in there?

Hope this is of any use!

 

[synapsevampire]

There are numerous proposed solutions to this.

Here's a FAQ by Howard Hammerman:

http://www.tek-tips.com/faqs.cfm?fid=5071

As VBrit suggested, you might also do this by correctiong the datasource to bring back the proper number of labels using a View or SP.

-k