Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Permission by department manager from single report to view. Expand / Collapse
Author
Message
Posted Saturday, May 11, 2013 9:49 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 11:55 AM
Points: 49, Visits: 362
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.
Post #1451881
Posted Monday, May 13, 2013 9:48 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, April 29, 2016 1:34 PM
Points: 783, Visits: 2,673
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.
Post #1452182
Posted Tuesday, May 14, 2013 2:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 26, 2015 1:05 AM
Points: 9, Visits: 40
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 ??
Post #1452423
Posted Tuesday, May 14, 2013 5:40 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, April 29, 2016 1:34 PM
Points: 783, Visits: 2,673
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.
Post #1452519
Posted Tuesday, May 14, 2013 9:28 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 11:55 AM
Points: 49, Visits: 362
Thanks for the tip.
Post #1452669
Posted Tuesday, May 14, 2013 9:29 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 11:55 AM
Points: 49, Visits: 362
True, thanks
Post #1452670
Posted Wednesday, May 15, 2013 6:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 27, 2016 5:28 AM
Points: 159, Visits: 254
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)
Post #1453041
Posted Wednesday, May 15, 2013 7:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 11:55 AM
Points: 49, Visits: 362
Thank you I appreciate the tip.
Post #1453105
Posted Wednesday, May 15, 2013 9:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 26, 2015 1:05 AM
Points: 9, Visits: 40
In agreement
Post #1453312
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse