COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 13 Dec 2010 11:40:38 AM

Title: value prompt values need to be changed based on Region selection
Post by: jd on 13 Dec 2010 11:40:38 AM
HI I have a prompt page with 4 prompts: Date, Region, Country and location.

based on Region Selection  Country and Location prompt values needs to be changed.

ex: if I select RegionA then Country should be XX,YY and Location should be a,b,c,d

    if I select RegionB then country should be GG,JJ and Location should be i,j,k,l like this.

I have tried adding conditional block but no luck. whatever Region I select Country and Location prompt values are not changing.
Title: Re: value prompt values need to be changed based on Region selection
Post by: mrcool on 13 Dec 2010 11:48:00 PM
Have you tried turning off Auto submit to no and placing Next button along with conditional block?
This may work.. but the problem is user should manually click the button once region prompt is selected.


Cheers,
Mrcool
Title: Re: value prompt values need to be changed based on Region selection
Post by: venkiatmaruthi on 14 Dec 2010 03:57:58 AM
Did you check with Cascade source option?

for Country prompt, go to Properties and in the General section you have option Cascade source
give there the parameter of Region.

Hope this helps.


Thanks.
Title: Re: value prompt values need to be changed based on Region selection
Post by: jd on 14 Dec 2010 09:37:52 AM
Thanks venkiatmaruthi,

I tried with Cascade prompting then it worked perfectly.