print copies based on numeric field

[Former Member]

I need to be able to print copies of my report results based on a numeric field within the report. In explanation, a customer may want 3 order forms. I will pull the report and print 3 forms based on his order. A report would be run daily and pull information for multiple customers with the number of copies of each customer's forms based on a numeric quantity pulled from a quantity field in each customer's order. We have been able to do this previously with another report writer program however we are soon switching to an SQL database and I am finding that our reports that I have converted to the SQL version of our report writer are not working. Would Crystal be able to accomplish this task and if so, how? I am a novice with Crystal and have been unable to find anything in the HELP section or within this forum that can help me.

[Former Member · Accepted solution]

This is probably not as straight forward as you're hoping, but it is doable... (If someone knows an easier way, I'd love to hear it...)

You would need to base your report on an SQL Command, which is basically a stored procedure within the Crystal Report. You would then fill a temp table with the data needed, duplicating the records for each copy desired. Return the resulting temp table data to the report. In that temp table, you'd have a Copy_Number field stating which copy the data belongs to. Include this field in the Group Expert at the appropriate level (right after Order_Number, for example). The Crystal Report wouldn't really "know" that it is creating the same form multiple times, but you'd get that result.

HTH,

Carl