OraFAQ Forum: Reports & Discoverer » One report, Multiple Copies

Home » Developer & Programmer » Reports & Discoverer » One report, Multiple Copies (Oracle 10g Report)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

One report, Multiple Copies [message #487884]

Mon, 03 January 2011 03:08

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

Dear All,

I am generating a report/invoice.
I want to print three copies of one report, one copy for consumer and one copy for bank and one copy for my official use.
all three copies should have proper lable,e.g consumer copy, bank copy and office copy.

how can it be done?
any help is appreciated.
regards.

Report message to a moderator

Re: One report, Multiple Copies [message #487911 is a reply to message #487884]

Mon, 03 January 2011 05:20

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Two options I can think of:

Create a report. Write "CONSUMER" somewhere in the outmost frame.
Then select all and copy/paste it below the original. Change "CONSUMER" to "BANK".
Do that once again, now changing "BANK" to "OFFICIAL USE".

Create a report, but this time the first query would be

select 'CONSUMER' who from dual
union
select 'BANK' from dual
union
select 'OFFICIAL USE' from dual

In Layout editor, its repeating frame should contain the "original" layout (invoice details; whatever you do in that report). The report would always contain 3 pages.

You could even put "who's" into a table so you'd, actually,

select who from some_table

and you could add other recipients later. If you put another column in there (such as "active"), you could distinguish whether to print someone's copy or not.

I think I prefer the second option.

Report message to a moderator