OraFAQ Forum: Reports & Discoverer » global variables in reports builder 10g

Home » Developer & Programmer » Reports & Discoverer » global variables in reports builder 10g (reports builder, 10g, XP)

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

global variables in reports builder 10g [message #333300]

Fri, 11 July 2008 03:13

rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon

Senior Member

Hi!
Can we define global variables in reports builder 10g?
If yes, how and where to create them??

Many thanks!

Rajy

Report message to a moderator

Re: global variables in reports builder 10g [message #333303 is a reply to message #333300]

Fri, 11 July 2008 03:37

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

Senior Member
Account Moderator

As far as I can tell, we can't do that; at least, not the way we can in Forms Builder as

:global.some_variable = 'abc';

or even

default_value('abc', 'global.some_variable);

What would you do with a global variable? In Reports Builder, you may create "User parameter" or store a variable in a package (if that's good enough for you).

Report message to a moderator

Re: global variables in reports builder 10g [message #333315 is a reply to message #333303]

Fri, 11 July 2008 03:59

rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon

Senior Member

Hi
I need to reference a field value in a formula column or format trigger of another field that is in a different group (at a different frequency).
I think a user parameter will solve MY problem because im just assigning '1' or '2' to this parameter. But if I need to assign a value from the query (:field), where to fill the parameter then??
Thank you!

Report message to a moderator

Previous Topic:	Parameter representation in the parameter form
Next Topic:	Dependent LOV for parameters on parameter form.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 14:52:01 CDT 2024