same report 3 times with different text value

[chuito7]

Hi:
I prepared an invoice in Crystal Report 8.5 using SQL databases. My customer needs to print the same invoice 3 times. The first one has to say "Original" the second one "Accounting" the third one "File". Also, that each invoice prints on a different paper color (they have a printer with multiple trays), this is important but not a most.

I'm grouping the report by invoice no, so when the invoice no changes it makes a page break. Actually they print their invoice in batch.

Any help on how to do this? I tried to make 3 copies of the same report and link but don't know how to link.

Thanks.
JC

 

[IdoMillet]

You can use a subreport approach or the technique I describe at: faq149-3226

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[MrBillSC]

How is your report laid out?
If there are multiple detail lines then you may have to use subreports. To do this, copy your main report to 2 sub reports. Make modifications to the subreports as needed. In your group footer for invoice number create sub-sections a and b. Place the subreports in footer a and b linking by invoice number.
As for selecting paper trays, I have never done that. Subreports slow things down and should be avoided whenever possible, but unless you can manipulate you data source by creating a view etc. the subreports may be your only option.

MrBill