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

Add fields to Include records where:

  1. From the left column, expand Application Details, expand Event Registrations, expand Registrant and select Event. From the middle column, drag Event record into Include records where. Search for your special event and click OK.
  2. To filter on a specific designation: In the left column, select Application Details. From the middle column, drag Designation system record ID to Include records where. Set this Equal to (or One of if you have multiple event related designations) and use the search to find your designation.
  3. If you use these designations year after year for your event, you may also want to add a date range in order to capture only this year’s donations: In the left column, select Revenue. From the middle column, drag Date into Include Records Where. Set Equal to or between to match the date range you want to consider.

Add Results Fields to Display:

  1. For Payment Date, the Date field is included in the Results Fields to Display of a Revenue query by default.
  2. For Payment Amount: In the left column, select Application Details. From the middle column, drag Amount into Results fields to display.
  3. To see the Designation: In the left column, select Application Details. From the middle column, drag Designation name into Results fields to display.
  4. To see what event registration option was purchased: In the left column, expand Application Details, expand Event Registrations, expand Registrant, and select Registrations. From the middle column, drag Registration Option into Results fields to display.
  5. To see if the event registration has a balance: In the left column, expand Application Details, expand Event Registrations, and select Registrant. From the middle column, drag Balance into Results fields to display.
  6. For Constituent Name and other constituent information: In the left column, expand Constituents. From the middle column, drag Name to Results fields to display.
Your final query will look similar to below:
User-added image