Cognos 8.4/Report Studio/ Data Base : Tera Data
I have 2 propmts in prompt page Product and supplier
Case 1 : select product and supplier is optional
Case 2 : Select Supplier and Product is optional
as soon as prompt page opens user has to select supplier or Product Prompt, then only prompt page allows for finish button
one selction is mandatory whether supplier or Product
case 3 : If we don't select supplier or Product -- finish Prompt button has to disable
(The prompt page should not allow for further step)
perhaps someone else can also chime in, but seems like in your case only some sort of a Javascript can help.
Could you start with a static choice radio button asking for a choice between product or supplier, then another prompt (data driven) which is conditionally populated with different data items depending on what is selected in the first radio button prompt (you'd also need a conditional filter)?
If you add a static choice for product such as *ALL PRODUCTS* and then a static choice for supplier such as *ALL SUPPLIERS* then both prompts can be mandatory. You'd have to account for those static choices in your filter expression.
Essentially they don't have to pick a specific product but could choose all. Of course this means they could choose the all option for both prompts which is probably not what you want. In that case you could make the filter expression return no data and then use a no data handler that detects this and provides a message instructing them about this.
I realize this isn't exactly the type of behavior you were looking for, but perhaps another avenue to consider...
could you please send me the Java script if any of you has idea on this ? appreciated for your answers
does this help
http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bjavascript&uid=swg21388290&loc=en_US&cs=utf-8&cc=us&lang=all
Not really ....
how'bout this
http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bjavascript&uid=swg21398683&loc=en_US&cs=utf-8&cc=us&lang=all
Radio button to select by supplier or product. Based on this selction, display conditionally formatted prompts.
Prompt set one is visible when radio button one is selected. It has supplier as required and product as optiona.
Prompt set two is visible when Button two is selected. It has product required and supplier optional.
Run button for both prompts is active when the required prompt is satisfied.
You should be able to have the filters in the report as both optional.
Should work, just did something similar this week.