OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Help in Reports... (Report Builder 6i)

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

Help in Reports... [message #308917]

Tue, 25 March 2008 23:24

omarq
Messages: 8
Registered: May 2006

Junior Member

Hello guys.

My problem is that i want to print a multi page report and i want a different title on each page. the problem is that i am using the "System Parameters - Copies" in order to define the number of copies. which means that the number of copies will be defined while printing. so how can i change the title while the report is been send to the "Print Job" ?

Thanks in advance.

Report message to a moderator

Re: Help in Reports... [message #308952 is a reply to message #308917]

Wed, 26 March 2008 01:08

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

Senior Member
Account Moderator

Here's an idea: create a (report) package and package variable which will be used as a page counter. Modify its value in BETWEEN PAGES report trigger and, accordingly to its value, set page title.

Report message to a moderator

Re: Help in Reports... [message #309009 is a reply to message #308917]

Wed, 26 March 2008 04:01

omarq
Messages: 8
Registered: May 2006

Junior Member

Thanks allot....

thats a nice idea, ill try it......

but i think i cant return any value from the TRIGGER(BETWEEN PAGES) SINCE it only returns boolean.

[Updated on: Wed, 26 March 2008 04:03]

Report message to a moderator

Re: Help in Reports... [message #309063 is a reply to message #309009]

Wed, 26 March 2008 06:15

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

Senior Member
Account Moderator

That's why you should use a package variable, modify its value and check it in order to display a title. Never mind the fact that the function (a trigger, actually) returns Boolean; you don't really use it anywhere.

Report message to a moderator

Re: Help in Reports... [message #309259 is a reply to message #308917]

Wed, 26 March 2008 23:02

omarq
Messages: 8
Registered: May 2006

Junior Member

I almost got you... i will try it.

thanks for the help Smile

Report message to a moderator

Previous Topic:	Discoverer eul and 11i business suite
Next Topic:	Null Value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 00:16:55 CDT 2024