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 on
I knew that we can get list of employee details using Recursive queries...
Is there any approach to get the same solution in SSRS

How to implement the above report using SSRS...Can you share your suggestions/direction/solution?