Views:


Applies to Product - Dynamics 365 Human Resources

What’s happening?
The Course instructors report does not display any instructors when accessed through the navigation path: Human resources > Reports > Courses > Setup > Course instructors report.
 

Reason:
This is caused by the data source query of the report design not including the Course instructor name/ID.
 

Resolution:
This report originated in an earlier system era (D365 HR Standalone), and over time, the data structure has changed, resulting in the information related to courses and their instructor IDs/names being distributed across multiple tables. The product team has not yet updated the report to align with the new database structure.
In the meantime, option could be to examine the customization aspect in the SSRS report to include the necessary information regarding the courses and their corresponding instructor ID/name from the following tables:

  • HRMCOURSETABLE
  • HRMCOURSEINSTRUCTOR (Field: Instructor ID)
  • DIRPARTYTABLE (Field: Name)
Alternatively, explore the use of Electronic Reporting (ER) as a potential solution. For further information, refer to Electronic reporting (ER) overview - Finance & Operations | Dynamics 365 | Microsoft Learn