Start your query:
  1. Navigate to Analysis, then click on Information library
  2. Click Add an ad-hoc query.
  3. Select the source view of Constituents and click Ok.

Add fields to Include records where: 
  1. In the left column, expand Registrant, then select Event.  
  2. In the middle column, click on Event Record and move this to Include Records Where. Set the criteria equal to the special event.
  3. In the left column, expand Invitee, then click on Event. In the middle, click on Event Record and move this to Include Records Where. Set the criteria Equal to the special event.
  4. In the Include Records Where section, click on the first line of criteria (Registrant\event\event record is equal to X) and click on the Add left parentheses button.
  5. Then, click on the second line of criteria (Invitee\Event\Event Record is equal to X) and click the OR button, then the Add right parentheses button.

Add fields to Results fields to display: 
  1. For registrant name: From the left column, select Registrant. From the middle drag Name into Results fields to display.
  2. For registration option: From the left column, expand Registrant, then select Mapped Registrations. From the middle column, drag Registration option into Results fields to display.
  3. To see the Host name, if the registrant is a guest: From the left, expand Registrant, then select Host. From the middle, drag Name into Results fields to display.
  4. Go to the Set Save options tab, name and save the query.
User-added image