We are a service provider that uses our moodle site as an LMS for company trainings. Companies contract with us to provide online training to their employees. The trainings are individual courses and companies are setup as Groups within each necessary course.
Currently status reports need to be requested from us by the client, we use a custom SQL Report to pull a site-wide status report that uses the Institution user profile field as a filter.
We are looking to allow the company contact the ability to pull this same (or a similar) report using their login that will also pull the site-wide (multiple course) report, but ONLY if the users Institution field matches there own.
Has anyone needed or developed a report to use here? I have a friend who does similar work, but not moodle, and he said the report would need to associate characteristics of the "report puller" to match to user fields, and that is the hurdle we would need to figure out first. Looking forward to any assist someone may be able to add.
Please let me know if additional information would help!