If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Render Report Objects based on Parameter

Started by dbe, 25 Nov 2011 03:05:06 AM

Previous topic - Next topic

dbe

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?  :-\

Gopinath

Try creating one Boolean variable for each of the Report objects with expression:

ParamDisplayValue('Prompt_Name') Contains 'Value'

dbe

Hi Gopinath,

Nice one!
Thanks for the advice...

I feel really stupid now, not having thought about that.
It seems so obvious!  :P

cognostechie

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 ?  ;)