To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Error with report
Summary
When I add a location table I lose over 100 enrollmentsContent
I started by creating a report of future enrollments. I have the following tables
- LearnCenters
- Users
- enrollments
- 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.