Post reply

Permission by department manager from single report to view.

  • May 11, 2013 at 9:49 pm

    #394760

    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.

  • 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.

  • May 14, 2013 at 2:25 am

    #1614857

    Hi

    I am not expert but hard coding is not a good idea, tomorrw the coder leave and some new dept. to be included then what ??

  • May 14, 2013 at 5:40 am

    #1614942

    nitin.lokhande (5/14/2013)

    Hi

    I am not expert but hard coding is not a good idea, tomorrw the coder leave and some new dept. to be included then what ??

    Copying the same report to multiple folders isn't really a great idea either. And if the coder leaves, who's going to set up the report for a new department anyway? To be clear, I'm suggesting hard-coding at the report level, not within the SQL itself.


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

  • May 14, 2013 at 9:28 am

    #1615064

    Thanks for the tip. 🙂

  • May 14, 2013 at 9:29 am

    #1615065

    True, thanks:-)

  • May 15, 2013 at 6:16 am

    #1615372

    You can also do additional table with permissions... like this:

    tabBudget will contain columns:

    [...]

    departamentID

    cash

    date

    [...]

    tabDeptUserPermissions will contain columns:

    ID

    departamentID

    user

    and in reporting services when You pull data from tabBudget do join with tabDeptUserPermissions on (tabBudget.departamentID = tabDeptUserPermissions.departamentID) and where tabDeptUserPermissions.user = User!UserID (not sure - this should be assigned to hidden parameter and this parameter should be used in query)

  • May 15, 2013 at 7:52 am

    #1615431

    Thank you I appreciate the tip.:-)

  • May 15, 2013 at 9:29 pm

    #1615600

    In agreement 🙂

Viewing 9 posts - 1 through 8 (of 8 total)

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