Dear All
Need your help in achieving this (Or knowing if its not possible) in Cognos 10.1.1
I have two Radio Button Prompts on my report page. I also have two lists on my report page. My requirement is - As soon as I click on 1st prompt , the 1st list should be visible (along with filtered data from 1st prompt). When I click on the 2nd prompt, the 2nd list should only be visible Along with filtered data from 2nd prompt) and the 1st list should hide. I tried this using conditional block but cant get anywhere. Also could not find something in javascript where I could deselect the 1st prompt if the 2nd one is selected etc but cannot get to a solution.
Would be grateful for help.
Regrds
Shuks
Hi
I'd suggets you need to set render variables on the lists. Set up a variable so you know which list is required. You can then set the render variable on the list to only show (render) it when required.
Hope that helps
Hi Wyco,
Thanks for your reply. Could you please elaborate more ? The problem is that even though I am toggling between prompt 1 and 2, both of them are selected at all times. For example , I select X on prompt 1 to show list 1 and then select A on prompt 2 to show list 2 - at this point the prompt 1 is still selected with value X. So if I try to use a render variable, it will render both the lists/crosstabs since both the prompts are selected. Please let me know your thoughts .
Regards
Shuks
Hi
You could still use the render variable but you need to be specific how you code the variable.
For example if you want to how list 1 when prompt 1 = x and prompt 2 <> a and you want to show list 2 when prompt 1 = x and prompt 2 = a then you could code a string variable as something like
IF (?prompt1? = 'x' and ?prompt2? <> 'a'') then ('list1') else
( IF (?prompt1? = 'x' and ?prompt2? = 'a'') then ('list2') else ('other') )
This would give you 3 possible values (which you will need to add)
You can then add the render variable to the list and render list 1 where the value of the variable = 'list1' and render list2 where it is 'list2'
You just need to make sure the logic for your variable is good enough.
Hope that helps
Hi Wyco,
Apologies for getting back after so many days. I see your point and its a very good suggestion. I'll give it a try. Thanks once again for getting back :)
Regards
Shuks