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

 

displaying values in one prompt based on another prompt value

Started by muraliredy, 22 Sep 2006 07:51:36 AM

Previous topic - Next topic

muraliredy

Hi,
    My requirment is like, I have 3 prompt say all the 3 are drop down list
1) Item classification
2) Item Subclassification
3) Item

Req1
*****
when user select a item classification value then correspoding Item subclassification values must be displayed in item subclassification drop down list, Similarly when item subclassification value is selected respective items must be displayed in items drop down list. I hear that this can be done by cascading property but when i use that untill i select the parent item value the child list value is disabled is there any other way to get the item enabled so that user can select values based on the selection


Req2
****
When user select an item value from item dop down list  subsequent item classification and sub classification values must be displayed in the respective fields

i want to know whether the above two requ can be done or is there any restriction in cognos

can you please suggest me how the above two requirments can be solved






Declan

2 ways to go here if your in Report Studio.

1. try a tree prompt if your item class -> item are in a hierarchy. It looks groovy and allows users to select multiple values (make sure you set the query to be IN not =). 

2.  Cascading prompts create a prompt for each level i.e. item class item subclass and item.  The cascade source is then set to the parametr for the parent so item sublass cascade source is item class and item cascade source is item subclass.

There is a tutorial somewhere on this site that show you how.  PS you anly need to use the item query in the filter for your query.

Hope this helps Declan :)