Visibility of report for specific users

• CrazySam

  SSC Enthusiast

  Points: 107

  More actions

  February 23, 2015 at 4:45 pm

  #398064

  In my report folder, there are 5 reports and i want to display 3 reports to specific user group who logged in and other 2 reports for administrator user group who logs in using windows authentication. How to set up the security and visiblity in my report manager.

• sql Sarah

  SSCrazy

  Points: 2081

  More actions

  March 10, 2015 at 8:29 am

  #1782947

  Can you create separate folders for each group? That way you can set the security at the folder level.

• Black_T

  SSC Veteran

  Points: 259

  More actions

  March 30, 2015 at 11:05 pm

  #1787557

  Hi

  In SSRS, it has a build-in field called UserID which is the current username. So you can set the visibility expression based on this field.

  https://msdn.microsoft.com/en-us/library/dd255235.aspx