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 |
|
rajan.nithin
Starting Member
42 Posts |
 Posted - 2012-01-23 : 05:13:08
|
| Hi,I have deployed a report say Report1 on my report server running on Sql Server 2008 R2.I have created two roles rol1 & rol2 .My report Report1 has the following fields.Col1 Col2 Col3 Col4Now my requirement is that rol1 should be able to view the whole report whereas rol2 should have a restricted view, i.e, he should be able to view only the fields Col1 & Col2 and the fields Col3 & Col4 shoud be hidden.Is it possible? If yes how can I do this?Regards,Nithin |
|
|
biswajitdas
Starting Member
44 Posts |
Posted - 2012-01-23 : 13:57:03
|
| This can be done by using the visibility property of the column.Sr Sql server DBA/Artitech |
 |
|
|
rajan.nithin
Starting Member
42 Posts |
Posted - 2012-01-25 : 03:25:04
|
Thank You !!!!!!!!!quote:
Originally posted by biswajitdas
This can be done by using the visibility property of the column.Sr Sql server DBA/Artitech
|
|
|
|
|
|
|
Report Access based on user role in SSRS 208 R2.