Coaching - Reports
Do you want to evaluate which of the persons you coach have received a certificate, or get an overview of their absences and open booking orders? In the "Reports" area of the Coaching Tool, you generate an Excel file from a report template for this purpose. The templates are grouped into categories, such as Certificates, Absences and Booking orders, and you only see the templates you are allowed to run.
Who can run certificate reports?
The report templates of the category "Certificates" are available to the following roles:
- Coaches of courses
- Coaches of educational products
- Line managers
- Education managers
The report contains the certificate data of the persons you are responsible for in this role.
You do not see the Reports button?
The Coaching Tool shows the "Reports" button to coaches of courses, owners of learning resources, line managers and education managers. The page Coaching - Overview describes when the "Coaching" entry appears in the main menu. The page Assign roles explains how roles are assigned.
How to create an Excel report
- Open
Coaching > Reportsin the main menu. The "Reports" button is in the "Assignments" section. - In the "Report templates" table, click the "Generate report" icon in the "Run" column of the desired template.
- OpenOlat generates the report as an Excel file (.xlsx) and lists it in the "Export history" section.
- Click "Download" next to the generated report.

Report templates
In the "Report templates" table, you choose which report you generate. It shows the name, category, description and type ("Static" or "Dynamic") of each template as well as the "Run" column. Use the "Category" filter to narrow down the list.

Templates of the category Certificates
| Name | Description |
|---|---|
| All certificates | Provides information on all certificates issued. |
| Certificates issued - last 4 weeks | Provides information about all certificates that have been issued in the last 4 weeks. |
| Certificates issued - last 12 months | Provides information about all certificates that have been issued in the last 12 months. |
The generated Excel file contains the worksheet "Individual courses" and, if the Course Planner module is active, an additional worksheet "Products". The page Reports: Certificates shows the structure of the worksheets.
Templates of the categories Booking orders and Absences
These templates are shown to line managers and education managers whose organisation grants them the right "Booking orders report" or "Absence report". Administrators assign these rights in the system administration under Administration > Modules > Organisations, see Module Organisations.
| Name | Description |
|---|---|
| Open booking orders - Last 4 weeks | Contains the open booking orders of the last 4 weeks. |
| Open booking orders - Last 12 months | Contains the open booking orders of the last 12 months. |
| Absences - Last 4 weeks | Contains the absences of the last 4 weeks. |
| Absences - Last 12 months | Contains the absences of the last 12 months. |
The page Reports: Booking orders describes the columns of the booking orders report.
Export history
The "Export history" section contains the Excel files you have generated. Each file is available for download for 10 days after creation, and OpenOlat shows the remaining days next to the file. With the "Info", "Copy to", "Delete" and "Download" buttons next to the file, you view details, copy the file, delete it or download it. The list only contains reports that you generated yourself. The "Delete my exports" and "Delete all exports" buttons therefore both remove all files of the list at once.

Further information
Mentioned on this page
Coaching - Overview >
Assign roles >
Reports: Certificates >
Module Organisations >
Reports: Booking orders >
Further reading
Coaching: User search >
Coaching: People >
Coaching: Courses >
Coaching: Educational products >
Coaching: Events / Absences >
Coaching: Assessment orders >
Coaching: Groups >
Coaching: Order management >
Assessment tool >