Print Multiple Copies of Same Report

[sathandle]

I have an order fulfillment application that is trying to print multiple copies of the same order so the entire order document can be placed on each individual box.

How can I have Reporting Services print the order X times with a number on each print? Therefore, if I need 7 copies of Order #1001, it prints 1001-1; 1001-2; 1001-3; etc. X varies by the order, but is calculatable.

Another option I have considered:
Re-create the data source with 7 copies of the order, each being numbered 1001-1; 1001-2; 1001-3; etc.

Thoughts? Ideas for implementation?


Don't beat your head against the wall unless you know how to plaster.

 

[sathandle]

It seems as if someone else has had similar issues.

r937 answered my post in the SQL Server Programming Forum and I thought it would be appropriate to post the answer here as well (I posted in both forums).

see thread 701-553683 in "Access Queries and JET SQL Forum"

It has been a GOOD day programming!!!

Thank you,
SATHandle

Don't beat your head against the wall unless you know how to plaster.