Need enrollment report with session locations
Summary
Was able to run the report without the locationContent
I have a report that has run successfully until I added the views and joins for ILT Sessions and Locations. Now when I run the report, I don't get any results. I need this report to show the enrollment names for the following month, some user fields, and the enrollment/session location. I have tried all the different types of joins for ILT Sessions and Locations (Inner, Left, Right, Full) to get the location to appear with the enrollment data. What am I missing?
I have attached a screen shot of my summary and the olbr file.