Displaying list of values 1

[dideb]

Hello All,

I have a column in a report created by playing in the SQL of the report.
Now I need to prompt on that report.
I inserted the following in the Where Clause of the SQL:
"Where AI LIKE @variable('Action Item:')"

It works fine except that the "VALUES" button is dimmed.
Any ideas about how to produce a list of values to the users.
Can i get the values from a text file or a dummy table like in Cognos?

Note: I am not allowed to modify the Universe.


Thank you,

Diaa

 

[skrandel]

If you want LOVs for this object you will need to talk to the universe developer.

Have you built this via a regular prompt? If so, and the LOV is still not available, then it's disabled at the universe level.

THe only thing you can try is to use @Prompt instead of @variable.

Steve Krandel
VERITAS Software

 

[dideb]

Hello skrandel,

As you said, @prompt worked.
I problem i am facing now is how to preserve the "%" sign in the prompt to produce all records.
Unlike @variable prompts, the value is reset when re-opening the report. So "%" is not there.
Silly but required...


Thank you,

Diaa

 

[skrandel]

No. That's not usually the case. Make sure you save the report after you run it. Values in @prompt should be saved as well.

Steve Krandel
VERITAS Software