Print duplicates of the same group 2

[ianoctdec]

Hi,
Crystal Reports 10, Oracle database
I have created a report to print invoices. The report has a group (InvoiceID), each inv prints on a separate page and can have one or more pages. What I need to do is to print three copies of each invoice, each copy having a different text on it: like 'Customer Copy', 'Accounting Copy', 'Manager Copy'. Can this be accomplished in one report? I would appreciate any ideas.

Thank you,
Dana

 

[synapsevampire]

If you can house all of the information required in the Details, right click the details and select insert section below and turn on the new page after for each section to create 3 copies per row.

Otherwise you'll have to imitate this in some fashion, which is difficult toi describe without an understanding of the report layout.

-k

 

[kenhamady]

If you can add a table to the database you can create a small table with three rows in it and link this to the existing table to force every record to repeat three times. In your new table put in the words:

Customer Copy
Accounting Copy
Manager Copy

Then link this using a Not Equal to join to any character field in your details. Once you group by invoice add another group by the new table's field.


Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- TEK2(AT)kenhamady.com

 

[ianoctdec]

Hi,
Just wanted to follow up with this, not before say 'thanks' to ken and synapsevampire.

SELECT CASE WHEN ROWNUM = 1 THEN 'ORIGINAL'
WHEN ROWNUM = 2 THEN 'ACCOUNTING'
WHEN ROWNUM = 3 THEN 'ACCOUNT RECEIVABLE'
END AS COPY_TYPE
FROM PART
WHERE ROWNUM <= 3

We are using business views, inserted this query as a table in the data foundation (might be linked with a not equal join or might as well be left it unlinked), and here we are, each invoice prints in three copies one after another.
An issue still remains, as we would like to be able to print one copy from a different tray (different paper color). If somebody has some ideas, solution, it would be greatly appreciated.

Dana



Regards,

Daniela

 

[IdoMillet]

I have an FAQ that addresses the original question as well as more advanced situations at: faq149-3226

In terms of printing different pages from different trays, there is at least one 3rd-Party Report Manager among those listed at:

http://www.kenhamady.com/bookmarks.html

that can do this.

Cheers,
- Ido



Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com