We can build the following query to review donations made to a specific designation through Daily Sales. 
  1. From Analysis, Click Information Library
  2. Click Add an Ad-Hoc Query, Choose the Source view of Sales Order
  3. In Include Records Where:
    1. To filter on the sales method. From the middle drag Sales Method Type to Include records where and set equal to Daily Sales
    2. (Optional) To filter on a specific date or date range. From the middle drag Transaction Date to Include records where and set 'is X' or 'between X and Y
    3. To filter on a specific designation. On the left expand Sales Order Item, Expand Sales Order Item Donation. click Designation. From the middle drag Designation Record to Include records where and set equal to the designation
      User-added image
  4. In Results Fields to Display
    1. To see the Constituent Name. On the left click Constituents, from the middle drag Name to Results fields to display
    2. To see the transaction date. On the left click Sales Orders. From the middle drag Transaction date to Results fields to display
    3. To see the amount donated. On the left click Sales Order Item. From the middle drag Net Amount to Results fields to display
    4. To see total sales order amount. On the left click Sales Orders. From the middle drag Amount to Results fields to display
      User-added image