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
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