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

How to hide report column what valueprompt value select

Started by BMbabu, 13 Jul 2010 01:12:38 AM

Previous topic - Next topic

BMbabu

I have a valueprompt(sigle select promptu),that contain A,B,C values is there And report contain X,Y,Z columns,
When am select A or B promptu values ,Ineed to display only X,Y Columns only
When am select C promptu value ,i need to display X,Y,Z Columns

I need help

Thanks and regard
Madhubabu

mvjcognos

By using render variable it is possible.....

1) Take a value prompt dont enter any thing finish button then by using static choices enter ur column names based on how many columns are there.
2) Go to boolean variable create paramdisplayvalue('parameter') contains 'a'
like this u create if u have five culumns are there create that many boolean variables but put instead of 'a' ur culmn name what u have entered in the static choices.
3) Go to the report cilck on 1 st column go to ancestor button select list column and then from properties select reder variable boolean1 for 1st column, repeat same steps for all columns.
4) Run the report select a,b,e in the prompt the report output will show three columns........

Regards
mvjcognos@gmail.com