COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jasp on 27 May 2011 10:22:12 AM

Title: Prompt selection - Rendering another prompt
Post by: jasp on 27 May 2011 10:22:12 AM
Hi All,

i was wondering if anyone could provide any advice.

I have a value prompt (UI = radio) with two static choices either 1 column or 2 column. (I have set the value prompt to multiselect = no
)
Depending on the user selection of the above i would like either another value prompt to appear if they select one, or two value prompts appear if they select two. The two value prompts being month prompts.

I have created a boolean variable as follows ParamValue('p_choice') = '1'

Then created the two value prompts in the prompt page. Then i have selected the second value prompt and applied a style variable to it using the above boolean.

Then i used the condional explorer and selcted "yes" and then used box type in the properties section to none. ie if the paramvalue = 1 then the second prompt will not appear.

I thought the above would work, but when i run the report and select either 1 or 2 on the first prompt nothing happens. I then changed the initial prompt to autosubmit and still it did not work.

I tried the above for rendering and conditonal blocks but still to no avail. i got it to work if i create another prompt page (2) , but i would like to only have one prompt page. I have read the other posts relating to the issue but still not got it to work.
Any advice on where i am going wrong
Title: Re: Prompt selection - Rendering another prompt
Post by: technomorph on 27 May 2011 11:42:24 AM
I've done this in the past using a conditional block, so it definitely works. I can't test at the moment, but try using a String variable instead of a boolean.
Cheers
Title: Re: Prompt selection - Rendering another prompt
Post by: jasp on 27 May 2011 03:16:05 PM
I found a solution to the above.

For some reason the auto submit was not working properly in the report.

The report is now working.

thanks