Function like Excel's "INDIRECT()"

building reports webintelligence
1

Hi

In excel if I want to access cell C5, I can use the formula INDIRECT(“C”&“5”) which will return the contents of cell C5.

Is it possible to do something similar in WebIntelligence, e.g. if I want to reference an object called [Level_5], can I use a variable that contains the number 5, e.g. “Level_”+[Number]?

Thanks

John

jrdavie (BOB member since 2010-11-24)

2

Hi,

Unfortunately this is not possible. You have to reference an object/variable in a report with its full name.

Marek Chladny :slovakia: (BOB member since 2003-11-27)