Start your query:

  1. Navigate to Analysis, then click on Information Library
  2. Click Add an ad-hoc query
  3. Select source view of Revenue and click OK


Add fields to Include records where:

    1. From the center box labeled Select Revenue Fields, drag Transaction type into Include records where:
    2. Set Transaction type to Order
    3. From the left column, select Sales Order
    4. From the center, drag Sales method type to the Include records where:
    5. Set Sales method type to your sales method
    6. From the left column, expand Application details Program and highlight Program Events
    7. Select Event Record from the center column and set the criteria to your event

    Add fields to Results fields to display:
      1. To add Names: From the left column, select Constituent. From the middle column, drag Name into Results fields to display.
      2. To see addresses: From the left column select Address(Primary). From the middle column, drag Address line 1, Address line 2, City, State abbreviation, Zip

      Here is an example of what your final query will look like: 
      User-added image