Step 1: Start Your Query
  1. Go to Analysis > Information Library
  2. Click Add an Ad-hoc Query
  3. Choose the Source view of Sales Orders
Step 2: Add fields to Include records where to indicate what groups you'd like to report on
  1. To add a filter for the date the program events occurred. On the left, expand Sales Order Item, Expand Sales Order Item Ticket, Click Program Events. From the middle, drag Start Date to Include records where and set between X and Y
  2. To add filter to look at members. On the left, expand Constituent, expand Members, click Memberships. From the middle drag Status to Include records where and set equal to Active
  3. (Optional) If you would like to only filter on events within a specific program. On the left, expand Sales Order Item, Expand Sales Order Item Ticket, Click Program. From the middle drag Program record to Include records where and set equal to your program.
Step 3: Next, we will add fields to Results Fields to Display to view details about the purchasers
  1. To output the Member's name who purchased the tickets. On the left, click constituents. From the middle drag Name to Results fields to display.
  2. To output the number of tickets the member purchased. On the left, click Sales Order Item. From the middle drag Quantity to Results fields to display
  3. To output the name of the program event tickets were purchased to. On the left expand Sales Order Item, Expand Sales Order Item tickets, click Program Events. From the middle drag to Results fields to display