Calling an external database

  • Andrew Goffin-302397

    SSC Veteran

    Points: 236

    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

    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

    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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply