Report Access based on user role in SSRS 208 R2.

• Hakuna Matata

  SSCertifiable

  Points: 5577

  More actions

  January 23, 2012 at 3:09 am

  #251590

  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 Col4

  Now 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

• Jared

  SSC Guru

  Points: 61793

  More actions

  January 23, 2012 at 8:30 am

  #1437149

  Have a look here. It is for 2005, but should be applicable to 2008 as well.

  http://stackoverflow.com/questions/726783/reporting-services-hide-table-column-based-upon-report-parameter

  Jared
  CE - Microsoft

• Hakuna Matata

  SSCertifiable

  Points: 5577

  More actions

  January 25, 2012 at 1:39 am

  #1438128

  Thank you Jared !!!!!