Home Forums Reporting Services Reporting Services Permission by department manager from single report to view. RE: Permission by department manager from single report to view.

  • May 13, 2013 at 9:48 am

    #1614664

    alex_martinez (5/11/2013)

    Hello,

    We are using SSRS 2005 and I have a report I want to give access to 5 different managers the report will be in a separate folders by department this report is a budget report. I don't want to change the sql query for each department individually and copy into the respective folders I would have ssrs 2005 recognize the department by folder and only give the data to the respective department manager. Is this possible? Thank you in advance.

    What about altering the query to accept the department as a parameter? When you deploy the report to your report server, you can hard-code this value for each folder.


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.