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

Cascade prompts with static choices

Started by handpass, 06 Jul 2007 05:39:11 AM

Previous topic - Next topic

handpass

list prompts.
In my first prompt I have 2 static choices. Depending on what is chosen in this first prompt I then want to display three more static choices in the second prompt, the values of which will depend on the first prompt selection. e.g.

IF Prompt1 = a
THEN
Prompt2 = a1, a2, a3
IF Prompt1 =b
THEN
Prompt2 = b1, b2, b3

I am hoping to have these two prompts on the one prompt page if that is possible. The values selected from the two prompts will be used as parameter filters in the report.

Thanks.

uttam.mistry

1. drag and drop value prompt to your prompt page
2. give parameter name as Prompt1 and press finish.
3. change Properties of value prompt as below:
    1. Enter static choices a and b.
    2. Auto-Submit = Yes
4. In conditional explorer create a new boolean variable 'Boolean1' with expression
      ParamDisplayValue('Prompt1') = 'a'
5. drag and drop another value prompt to your prompt page
6. give parameter name as Prompt2 and press finish.
7. change Properties of value prompt as below:
    1. Enter static choices a1 and a2.
    2. Cascade Source = Prompt1
    3. Style Variable = Boolean1
8. copy and paste Prompt 2
9. change Properties of value prompt as below:
    1. Enter static choices b1 and b2.
10. In conditional explorer for variable Boolean1 click to value 'Yes'
11. change Properties of value prompt created in step 8/9 as below:
    1. Box Type = none
12. In conditional explorer for variable Boolean1 click to value 'No'
13. change Properties of value prompt created in step 6/7 as below:
    1. Box Type = none

i hope this should work... if not let me know...