September 22, 2014 at 2:16 pm
So I have an SSRS report which basically displays the project and hours of every single employee in the company. However the data returned on the report is based upon who is currently running the report. This part is easy as I can just set the default of the "LoginID" parameter to the system variable "UserID" within SSRS. The part I am having trouble with is meeting the following conditions or trying to come up with a logic to support it:
-If a user/regular employee is running the report, then they can just view their project and hours and nobody else's.
-If a user/regular employee is also a manager, then they can view their project and hours as well as their direct reports' project and hours.
-If a user/regular employee is also a manager and their direct report is a manager, then they can view the direct report's employees as well.
--Note: Each employee has a LoginID and each manager has their own ManagerLoginID, so in essence if Tim is an employee and a manager then he will have both of these IDs.
So if anyone has worked on a similar scenario such as this or has any idea on how I can achieve this, whether it be on back-end (SQL coding) or through SSRS report design itself, please let me know. I would really appreciate the help as I have never done anything like this before. Thank you.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply