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

Report Prompts

Started by johny.cbi, 03 Aug 2010 09:49:50 AM

Previous topic - Next topic

johny.cbi


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)


Arsenal

perhaps someone else can also chime in, but seems like in your case only some sort of a Javascript can help.

JGirl

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)?

Lynn

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...

johny.cbi

#4
could you please send me the Java script if any of you has idea on this ? appreciated for your answers


johny.cbi



Steve-O

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.