My table structure is Event > Event Shift > Shift Participant. I was able to create a report using the report wizard that shows participants signed up under each shift. To run the report, users have to go to the Event Shift sub-grid, click the three dots, click run report, click the report, THEN click only records in selected view. Is there an easier way to do this? Ideally there would just be a component button that would generate this report somehow from the main form. The report wizard is limited to 1 related entity, so maybe I need to use an alternative method? Any help is much appreciated!

Report
All responses (
Answers (