Display Column on User Preferecnce.

[cognos.cognosbi@gmail.com]

Hi,
i have 5 columns in my Report.example Emp Name,Emp id,Salary,City,Adress.if One User Run the report Just i want to show 3 columns Emp Name,Emp id,Salary.for other Users it will show all the columns.
Please any one Help me..

Thanks,
Cool Cognos

[rockytopmark]

Yep... few ways this can be done.  Here is a simple way with no custom coding:

1. Create 5 prompt controls... 1 for each column.  They could be 1 of many varieties of prompt controls, so pick one that works for you.  Each Prompt should have a parameter assignment that coincides with the respective column.

2. Create 5 boolean conditional variables, again 1 for each column.  The expression would be built to return True or False, depending on how you set up the prompts.

3. In your list, select each column and assign it a Render Variable, obviously using the variable that coincides with the column.

If the user selects to show 3 columns, A, B and D, then the Render Variables would produce only those 3 columns.

HTH......... M