how to declare a global variable in report builder?

[MAHMAD337]

Hi all,
I want to declare a global variable in my report (build in oracle report builder).
can any one tell what is the procedure to declare a global variable in oracle report builder.
bye;

[amitpatel66]

A global variable??...Yo u mean a variable that you can use across report?

[Saii]

I dont think you can have global variables like forms in oracle reports. But maybe you can use placeholder columns in data model.

[Sport Girl]

try GLOBAL var NUMBER := value;
the global variable is available to all sessions, u just have to declare it once and use it everytime u need
u can use also bind variables in ur queries if u want to improve optimisation