Start Your Query
  1. Go to Analysis > Information Library
  2. Click Add an Ad-hoc Query
  3. Choose the Source view of Sales Orders and click OK

Add fields to Include records where:
  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.

Add fields to Results fields to display:
  1. To output the Member's name who purchased the tickets: In the left column, click constituents. From the middle drag Name to Results fields to display.
  2. To output the number of tickets the member purchased: In the left column, 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: In the left column, expand Sales Order Item, Expand Sales Order Item tickets, click Program Events. From the middle drag Name into Results fields to display.

Save your query:
  1. Click Set save options tab
  2. Name your query
  3. Save and Close