Hi,
I have a Prompt page with a Multi-Select Checkbox list in place.
This object has about 15 different options which can be checked by the User.
The checked objects are passed upon submission of the Prompt page.
What I would like to do, is create a String Variable checking each of the passed Parameter items.
This Variable will then be used as a Render Variable to dynamically show the related Report Objects.
I'm just wondering if it's possible in the Cognos Variables to loop through the Parameter items.
For example, something like this:
FOREACH ( ParamValue('prm_test') )
CASE ParamValue('prm_test')
WHEN '1' THEN 'Show_A'
WHEN '2' THEN 'Show_B'
WHEN '3' THEN 'Show_C'
ELSE 'Show_D'
END
END FOREACH
Anyone can help me out? :-\
Try creating one Boolean variable for each of the Report objects with expression:
ParamDisplayValue('Prompt_Name') Contains 'Value'
Hi Gopinath,
Nice one!
Thanks for the advice...
I feel really stupid now, not having thought about that.
It seems so obvious! :P
Naah ! All of us do that sometime or the other so no need to feel stupid. BTW, since you used FOREACH, are you from PROGRESS background ? ;)