Hi All,
Hopefully someone with a better grasp of SQL that I have can help me out. I have installed the Mentees block and the Configurable Reports block and both are working successfully, however I am trying to create 2 reports that the Mentor can pull in the Configurable reports block that will show the course information for just their people.
The first report needs to show only their own employee's completed courses. (I have this working already for each individual user, however I need to also have the mentor (Supervisor) be able to pull this for each of their people.)
The second report is similar to the first, but would need to show all courses both completed and enrolled for all of their employees and make it filterable by the employee (student) as well as by the course.
I hope this makes sense and that someone could help me with the SQL coding I would need for these.
Happy Holidays!!
Fred