Results 1 to 3 of 3

Thread: Permission by department manager from single report to view.

  1. #1
    Join Date
    Apr 2013
    Posts
    39

    Permission by department manager from single report to view.

    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?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Don't think ssrs will filter data for you. You can create sp for the report and pass department as parameter, each department will get its data only based on parameter.

  3. #3
    Join Date
    Apr 2013
    Posts
    39
    Thanks for the insight.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •