Hi All,
I have a Report with a Prompt page and a optional prompt.
When I run the report the filter is optional.
When I create a data item in the Query and use the optional prompt like:
IF ( ?PROMPT_FIELD? is missing )
THEN ( 1 )
ELSE ( 2 )
And use this data item in my list, the prompt filter becomes required.
Is this normal, or is our evironment (10.2.1.1) not ok?
BI4BUSINESS
This is normal behavior. Once you reference a prompt within the expression of a data item then the prompt is required.
Perhaps you could provide a default value for your prompt instead.