Report Problem with Repeats of Grouping Categories
Hi I am trying to make a report that has a list by Registrant and has the Attendees names underneath. Often times someone will purchase for a group and they may or not provide us with all the names of their guests so I need the Registrant name to be the category grouping and the attendee name to be the subcategory.
It has been reading the Registrant name as separate reservations for each new attendee I enter. It has been giving me the following:
What am I doing wrong how can I get it to group the way I need it to?
Please see image below to see the table I am working from. Could it be something to do with the way I have set up the table or is it how I'm setting up the report? Thanks!