Hi Bjorn, I've used the registrants details report for something like this. If you go to report templates --> registrants --> registrant details. On this report you can add each session as it's own column so you could add each of your 4 sessions as a column that has Yes/No values and that way you only have one row per registrant.
To further dive into your requirements you can add advanced filters in change report data and your selection criteria tab for breakouts.
Breakout One Name = Yes
OR
Breakout Two Name = Yes
This way you only have rows for registrants who have RSVP'ed for one of those sessions you had in mind for that day and you can add the columns for the sessions so the sales team can see which ones people are attending during that day. The only limitation is you can only add 5 advanced filters to a report at once. So if you have more than 5 you might be stuck doing some sorting manually in excel but shouldn't take long.
Best,
Evan
------------------------------
Evan Ring
Marketing Manager
Dow Jones & Co., Inc
------------------------------
Original Message:
Sent: 11-11-2021 11:39
From: Bjorn Schwarzenbach
Subject: Reporting - Pulling registrant info for a single day with multiple sessions
Hi everyone,
I haven't found a good solution to this reporting issue I have. I want to pull the registrant data for a single day (we have 4 sessions each day (morning/lunch etc.) taking place within a 3-day event. I have to send this report each morning of the event to our Sales team so that they can see who of their customers are attending that day. And I don't want to have that report list out specific customers for each session multiple times over the day's 4 sessions.
Has any one found a way to run a custom report for this?
Thanks in advance!
#Flex-Creating/ManagingEvents
------------------------------
Bjorn Schwarzenbach
------------------------------