Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
 Posted - 2013-10-25 : 09:07:35
|
| [code] I have several levels of users ( suppose think of Employees, managers, senior employees, directors and so on) If director logged into the report then he should be able to see all employee details;if manager then details of employees under him and all subordinates of those employees and so onI knew that we can get list of employee details using Recursive queries...Is there any approach to get the same solution in SSRS[/code]How to implement the above report using SSRS...Can you share your suggestions/direction/solution?--Chandu |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-25 : 09:24:29
|
| are all users domain users? or do you've a custom user table where you've setup hiererchy with roles?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
SSRS report Help