Calling an external database

• Andrew Goffin-302397

  SSC Veteran

  Points: 236

  More actions

  April 4, 2018 at 4:25 am

  #403225

  Hi,

  Is it possible to call a procedure or function within reporting services to determine whether the user is able to view the reports for the folder they are in ?

  Regards
  Andrew

• Thom A

  SSC Guru

  Points: 98653

  More actions

  April 4, 2018 at 4:52 am

  #1985421

  I'm not quite sure I understand your question here. Are you looking to to create an SSRS report which takes a username as input, to see what reports they can access within Reporting Services? How are you granting a user poermissions to specific folders? I believe this is much harder to do if you are using AD groups, but there probably is a way.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

• Andrew Goffin-302397

  SSC Veteran

  Points: 236

  More actions

  April 4, 2018 at 5:00 am

  #1985422

  To clarify that you tweak the configuration of reporting services so that when user is using the report it will know what folders/reports the user can see, restricting the data once a report is running, the straight forward bit.

  It seems that later version of reporting services can do this.