Home » Developer & Programmer » Reports & Discoverer » global variables in reports builder 10g (reports builder, 10g, XP)
global variables in reports builder 10g [message #333300] Fri, 11 July 2008 03:13 Go to next message
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
Re: global variables in reports builder 10g [message #333303 is a reply to message #333300] Fri, 11 July 2008 03:37 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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).
Re: global variables in reports builder 10g [message #333315 is a reply to message #333303] Fri, 11 July 2008 03:59 Go to previous message
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!
Previous Topic: Parameter representation in the parameter form
Next Topic: Dependent LOV for parameters on parameter form.
Goto Forum:
  


Current Time: Sat Dec 03 16:13:55 CST 2016

Total time taken to generate the page: 0.11382 seconds