OraFAQ Forum: Reports & Discoverer » Multiple copies of report with different footer

Home » Developer & Programmer » Reports & Discoverer » Multiple copies of report with different footer (Report 6i)

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

Multiple copies of report with different footer [message #550536]

Tue, 10 April 2012 03:32

elsy
Messages: 40
Registered: August 2006
Location: Kuwait

Member

Dear all
i am using reports 6i .

i want to Print Multiple copies of report

1 - Customer copy
2- Department copy
3- Finance Copy

Setting the number of copies to 3 will print 3 copies of the report. But i want for each report , the footer should differ .any body please tell me the solution

Thanks

Elsy

Report message to a moderator

Re: Multiple copies of report with different footer [message #550542 is a reply to message #550536]

Tue, 10 April 2012 04:35

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

Senior Member
Account Moderator

Two options I can think of.

Create another query:

select 'Customer copy' what from dual union
select 'Department copy' from dual union
select 'Finance copy' from dual

Now go to Paper Layout Editor and create objects related to that query - a repeating frame should contain ALL objects you already have in a report, as it will repeat the same stuff 3 times, once for each copy type. At the bottom of that frame, create a field whose source will be the WHAT column from the above query.

Another option is to create user parameter (for example, PAR_COPY) which will be passed at the time report is called. Depending on its value, you'd display copy type at the bottom of a report (either as a text (and use of a Format Trigger), or a field).

The second option is worse because it would require you to run the same report 3 times (which might be time consuming).

Report message to a moderator

Re: Multiple copies of report with different footer [message #550743 is a reply to message #550542]

Thu, 12 April 2012 01:47

elsy
Messages: 40
Registered: August 2006
Location: Kuwait

Member

i tried the first option of repeated frame. It worked fine .Thanks a lot

Report message to a moderator

Previous Topic:	Changing lov font face
Next Topic:	Unable to move fields

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 06:45:58 CST 2024