Error with report
SummaryWhen I add a location table I lose over 100 enrollments
I started by creating a report of future enrollments. I have the following tables
- Enrollments Progress
- ILT Session
When this report runs I get 2289 lines of data
When I add the Location table and join location to session I get 1692 lines of data. I lose 101 enrollments. I have double checked the session to make sure the sessions has a valid location and it does. I have worked on this report for several hours and clearly cannot see where the difference is coming from and why the it is skipping over some of the enrollments. Any help would be appreciated. I am including the export files for these two reports.