Start your query:
  1. Navigate to Analysis, then click on Information Library
  2. Click Add an ad-hoc query
  3. Select source view of Sales Order and click OK
Add fields to Include records where:
  1. In the left column, select Sales Order Item, then expand Sales Order Item Ticket and click Program. From the middle column, drag Program record into Include records where. Search for your program and click OK
Add fields to Results fields to display:
  1. To add the event name: From the left column, select Sales Order Item Ticket, then Program Events. From the middle column, drag Name into Results fields to display.
  2. To see the constituent name: From the left column, select Constituent. From the middle column, drag Name into Results fields to display.
  3. To output the refund total From the left column, select Sales Order Item, then Refunded item. From the middle column, drag Total into Results fields to display.
Here is an example of what your final query will look like:

User-added image