I'm trying to run a report for my auditors and as a year end close out report for all employees/all training assigned 2021. It should include the following info and should be run for active employees based on a date parameter with a flag to include archived employees:
- Employee name
- Date assigned
- Date completed
- Training Course Name
- Campaign Name
- Completed late flag identifier
There is a count report but it doesn't identify the specific training those individuals completed, and various other information like grades, date completed etc. Apparently there isn't an itemized report that will provide me a breakdown of every training completed by all employees within a date period.
There is a manual way to do it by campaign or by user, but:
- The process is very manual and users would have to consolidate all the training campaigns/user reports into one spreadsheet then clean up the data to display for what is being requested. This is not a good use of anyone's time, even if they did this quarterly that's a lot of work.
- There is a margin of error if you miss someone that has been archived.
- If you have a campaign where once the training is complete the employees are removed (New Hires), you receive a blank report. (I tried that)
I'm actually surprised this doesn't already exist as this is a standard report in training applications.