Dynamically Determine Existence of an Object on a Report

building reports desktopintelligence
1

Hi All,

Here’s my conundrum:

I want to determine at report runtime whether or not a particular universe object is being pulled into the report. If it does, I want to display a message. I don’t want to do this, however, via a data provider - I need to do this in the report itself.

What I was thinking was that I would place a cell with my message in the footer of the of the report template that all of our users use. The cell would be made visible or hidden based on whether or not it met the condition “object 1 is being used in this report”.

Any ideas on how I can accomplish this? Many thanks in advance.

Regards,
Solokan

solokan :us: (BOB member since 2003-02-19)

2

That won’t work because in Deski as soon as you take the object out, any formula you use against that will get an error and it then does not matter if you add it back, it does not automatically relink itself.

Short answer is that I don’t believe you can do what you are asking, but then again I have been proven wrong in the past.

Good luck

plessiusa :netherlands: (BOB member since 2004-03-22)

3

Thanks, Arjan. I was afraid of that. I tried it myself, and am encountering exactly what you described.

solokan :us: (BOB member since 2003-02-19)