Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GryphonsClaw
Starting Member
2 Posts |
 Posted - 2007-05-19 : 00:59:25
|
| If I wanted to make a report that shows different fields, one being cost, but I only wanted certain people to see cost based on their AD groups, is there a way to hide this information?Basically, domain/user1 belongs to AD purchasing group purchasing, he can see item, description and cost, where domain/user2 belongs to sales so he can only see item and description? |
|
|
jhermiz
3564 Posts |
Posted - 2007-05-21 : 13:50:33
|
quote:
Originally posted by GryphonsClaw
If I wanted to make a report that shows different fields, one being cost, but I only wanted certain people to see cost based on their AD groups, is there a way to hide this information?Basically, domain/user1 belongs to AD purchasing group purchasing, he can see item, description and cost, where domain/user2 belongs to sales so he can only see item and description?
Remember a report is just a dataset, data coming from your SQL box. So tell the query to return only specific fields based on case...in addition it is a parameter sent to the report's stored procedure stating what type of user is viewing the report. Based on that bring back the fields / records you need.Take a step back and look at the report as just code, if you can do it in code, the report will reflect that. Also even if you don't do it in code you can do it in the report itself. There is a visibility property for fields. Change it from True / False to an iif which can return true / false.=IIF(Fields.YourField.Value='YourValue', "True", "False")JonProgrammers HowTo's -- [url]http://jhermiz.googlepages.com[/url] |
 |
|
|
|
|
|
|
|
Hide Fields based on users AD member ship