In my Report Studio report I have a value prompt defined that has the usage set to optional, which allows the user to choose a specific value from the prompt or leave the prompt "untouched" so that all values get selected.
To check the value prompt for specific values, I have changed a Data Item expression on the report page and have added an IF THEN ELSE statement in this expression. See below.
IF (?Cost Center? = ' ') THEN
...
ELSE
...
A negative side effect of this is that the optional value prompt has now become mandatory, and the user now has to select a value from the prompt. How can I overcome this behavior?
for making the value prompt optional you can use javascript. For example in checkbox prompt
checkBoxListAAA.m_bRequired=false;
will make the checkbox as optional prompt where AAA is the checkbox's name. For list box use
listBoxAAA.m_Required=false;
For making the finish button becoming enabled use
checkBoxListAAA.m_bValid=true;
For list box
listBoxAAA.m_bValid=true;
hope this helps you
Even though you have that prompt set as optional, it becomes mandatory when you need that prompt's value to populate another data item. It is behaving as it is supposed to.
Are you trying to see if the Cost center prompt is not selected?
If that's the case, you can use if ?Costcenter? is null.
You can also use the case statement in the filter instead of data item and prompt will not be mandatory.