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

Add fields to Include records where:
  1. In the left column, select Group Sales Reservation. From the middle column, drag Reservation Records into Include records where. Set equal to the reservation.
  2. In the left column, select Status History. From the middle column, drag Status into Include records where. Set equal to Cancelled.

Add fields to Results fields to display:
  1. In the left column, select Status History. From the middle column, drag Date Changed into Results fields to display.
  2. From the same middle column, drag Change by username into Results fields to display.

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