Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 24, 2014 8:45 AM
Points: 8, Visits: 132
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: Today @ 12:43 PM
Points: 745, Visits: 2,021
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: Wednesday, July 17, 2013 4:27 AM
Points: 8, Visits: 36
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: Today @ 12:43 PM
Points: 745, Visits: 2,021
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
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 24, 2014 8:45 AM
Points: 8, Visits: 132
Thanks for the tip.
Post #1452669
Posted Tuesday, May 14, 2013 9:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 24, 2014 8:45 AM
Points: 8, Visits: 132
True, thanks
Post #1452670
Posted Wednesday, May 15, 2013 6:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 12:52 PM
Points: 17, Visits: 133
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
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 24, 2014 8:45 AM
Points: 8, Visits: 132
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: Wednesday, July 17, 2013 4:27 AM
Points: 8, Visits: 36
In agreement
Post #1453312
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse