Home » Developer & Programmer » Reports & Discoverer » One report, Multiple Copies (Oracle 10g Report)
icon2.gif  One report, Multiple Copies [message #487884] Mon, 03 January 2011 03:08 Go to next message
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.
Re: One report, Multiple Copies [message #487911 is a reply to message #487884] Mon, 03 January 2011 05:20 Go to previous messageGo to next message
Messages: 21809
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
select 'BANK' from dual
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.
Re: One report, Multiple Copies [message #487971 is a reply to message #487911] Mon, 03 January 2011 22:32 Go to previous messageGo to next message
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Hope srw.run_report will help you on this.
See the help topics in report Builder for this.

Re: One report, Multiple Copies [message #602322 is a reply to message #487884] Tue, 03 December 2013 03:49 Go to previous message
Messages: 615
Registered: August 2002
Senior Member
  • Attachment: untitled1.JPG
    (Size: 52.61KB, Downloaded 2543 times)
Previous Topic: Reading BLOB Images takes long time
Next Topic: Issue with binding parameter in Data wizard query
Goto Forum:

Current Time: Sat May 18 10:43:19 CDT 2024