BusinessObjects Board

Prompts issue

Hi,

I have prompts on a report.Iam using “In list” condition for the prompts.All the users need is for some prompts they will enter the values but forsome they just want leave them empty(none).Is there any way of doing it?.

Thankyou


rao (BOB member since 2003-06-02)

You might want to check out this idea that would allow users to put ‘all’ or a * in a prompt. This requires some work in the universe, but it works really well.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

Michael,

Does this code allows the users to run the report even if they dont select any values for some prompts?

Thankyou for the code


rao (BOB member since 2003-06-02)

No, they still need to put ‘all’ or a * in the prompt. However, prompts always default to the last value used. So if you publish a report with a * in all the prompts, then the users would only need to change the ones they want, and leave the rest alone.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

BO does not allow for empty prompts. Prompts have to be filled out before refreshing a data provider, either by the end-user or VBA macro.


Andreas :de: (BOB member since 2002-06-20)

Thankyou guys.So there is no way refreshing a report for empty prompts.


rao (BOB member since 2003-06-02)