If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Optional Value Prompts becoming mandatory ...

Started by kwierinc, 04 Jan 2008 09:36:30 AM

Previous topic - Next topic

kwierinc

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?

bharathkv

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

Suraj

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.