Step 1: Start your Query
  1. Go to Analysis > Information Library
  2. Click Add an ad-hoc query
  3. Select the source view of Registrants and click OK
Step 2: Add fields to Include records where
  1. First, we’ll add fields to see registrants for our event. From the left column, highlight Event and drag Event Record to Include records where. Set this to be equal to your event.
  2. In the left column, highlight Registrant at the very top and drag Is Guest to Include records where. Set this to be equal to No
    User-added image
Step 3: Add field to Results fields to display
  1. In the left hand column, highlight Registrations. From the middle column, drag Quantity, Registration Fee, Registration Option, and Registration Type (if needed) to Results Fields to Display
  2. You can also rename any of these fields to help you easily identify them
    User-added image
Step 4: Save your Query
  1. On the set save options tab, Name your query
  2. Mark the Box to Create a Selection
  3. Save and Close