Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Column level security in report

Status
Not open for further replies.

volcano

Programmer
Aug 29, 2000
136
HK
Hi, I am facing a problem that there is a Cognos report in which a column out of, say, 10 can only be viewed by report administrator. The other 9 columns can be viewed by all common users. Could anyone tell me any hint of how to do so? It seems the package, data and object securities taught in Framework Manager student guide are not possible solutions...
 
You should be able to conditionally hide the column when the user isn't an administrator using a macro. For example, we use this...

'Admin-group-name' in (#CSVIdentityNameList()#)

...as a filter in a dummy query which counts records in a small arbitrary table and then conditionally hide "admin only" things based on the data item in that query having a >0 value.
 
Here's a secondary question to this...

Can we determine the column names by the person looking at the report? We have a situation where depending on the customer (end user) we would want the columns to have certain names.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top