I'm sure I'm overlooking something obvious and hope someone can point me to the answer.

We had an event where people could purchase a ticket for themselves and guests (up to 3). That's all good. The thing is, I can't figure out how to run a report which shows the purchaser and who their guest/s is/are. I HAVE figured out how to see the "registered by participant ID" # (see below), but I'd love to see the name of the participant who registered the guest and I can't figure that out. I'd like to be able to see a report which shows the Registrant --> Guest(s)

enter image description here

It's possible I set this up incorrectly from the get-go - I'm a Civi newbie - but I appreciate any guidance anyone can offer!



If I am not wrong you need to know the "Registered by Participant ID"

I guess you know to find the report from the following path (menu)

Reports => Event Reports => Attendee List OR Event Participants List

In both the reports you do have a option displaying "columns"

just select "Registered by Participant ID" which should display

I guess this helps !!!

| improve this answer | |
  • Hi, Ramesh. I was able to construct that report (that's the image), but I can't figure out how to display the name associated with the "Registered by Participant ID." I looked for an extension that could do the job, but didn't find one. It might mean a custom report is needed or something like that. – LComstock Oct 24 '17 at 12:48
  • Yeah in this case you might have to use excel and a vlookup :( – RayWright Nov 23 '17 at 12:25

If you are using Drupal then I would look in to building a Drupal View to deliver the required information - not having tried for this particular outcome therefore flagging that it may require views_field_view so that you can use that id as a Contextual filter in a related view to get that Contact's name etc

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.