How to avoid Optional Prompt Text

[Former Member]

Hi Techies,

I have a optional prompt in my report defined at report level,

when I run the Query the Prompt text is shown as

Example:-

"Enter Values............(Optional):" {if this value is no selected then the filter will be ignored.}.

Now my question is how to avoid the text showing in curly braces as shown in the example above.

Please do the need full.

I am working on BO 3.1 and back end data source is Oracle 10g.

Thanks in Advance ...........

[Former Member]

Hi Mark,

Thanks for your response,

the thing is that, the object should be an optional prompt and it should not show message other than Prompt text..

[Former Member]

Yes, I know what you need.

Two things:

If the prompt is optional, there is no option to not display the message.

Secondly, the option that I've suggested of using a case statement and a default value means that unless the default is changed, then all values are returned, in effect making the prompt optional. If you explain to users how it works, I'm sure they'd be fine seeing, say, "All Values" in the prompt and ignoring the prompt if they don't want to use it.

[Former Member]

You can't. The only way to stop the optional prompt being optional (and displaying optional) is to make it mandatory.

There are workarounds with defaults (hardcoded, not object-based) if you want a user to ignore the prompt if they are to treat it as optional.