I have a report I am running for events with subevents. The report runs off a query where the event code is inputted and the query lists the individual and the subevents they are in.
The output of the query is like this:
EventCode, SubeventName, Name, Address, Phone
The query is a simple select query which lists a registrant and their associated info 4 times if they are in 4 subevents.
On my report, I am showing one person per page, listing their info, and want to list all of the subevents they are in. How can I do this in my report? I have the report currently setup to group by registrant name and that is it.
Thanks in advance for your help.
The output of the query is like this:
EventCode, SubeventName, Name, Address, Phone
The query is a simple select query which lists a registrant and their associated info 4 times if they are in 4 subevents.
On my report, I am showing one person per page, listing their info, and want to list all of the subevents they are in. How can I do this in my report? I have the report currently setup to group by registrant name and that is it.
Thanks in advance for your help.
