COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kiran04 on 17 Jul 2012 10:13:52 AM

Title: How to set value prompt options not available
Post by: kiran04 on 17 Jul 2012 10:13:52 AM
Hi ,
I have a requirement where I need to set the value prompt options to be unavailable to the users.
for example .,  I have three value prompts , if I select first two value prompts then I need to set the third value prompt options to be unavailable (in grey ) but still I have to show the options there .
Conditions: these options are only be unavailable when the user selects only some options in the first two prompts and for others I need to show the third prompts options available.
If it is not clear please let me know and suggest how can it be done??

thanks,
KWAS04.
Title: Re: How to set value prompt options not available
Post by: tjohnson3050 on 17 Jul 2012 10:22:37 PM
Can't be done with default settings.  You could fake it by conditionally (using a conditional block based on a variable driven by the other prompts) showing a text box with the value prompt items displayed at just text with a grey background, then showing an actual prompt otherwise.
Title: Re: How to set value prompt options not available
Post by: Rahul Ganguli on 18 Jul 2012 05:51:33 AM
This can only be achieved with JavaScript, I have similar requiremnts in Past.
There is no out of box work around in Cognos without using JavaScript.

Regards,
Rahul
Title: Re: How to set value prompt options not available
Post by: kiran04 on 18 Jul 2012 09:41:10 AM
Hi Rahul,
Yes, I think it can only be done with javascript, if you have that script with you , can you please share with me.

thanks,
KWAS04.