1. Go to Analysis > Information Library.  Click Add an ad-hoc query.
  2. Select the Sales Order source view
  3. From the left hand column expand sales order item. Select sale order item discount. From the middle column select Discount name and drag it over to Include records where. Set it equal to the name of your discount. 
  4. Go to the set save options tab. Name your query and mark the box to create a selection and the box to show this selection in the Query designerUser-added image
  5. Hit save and close.
  6. Click Add an ad-hoc query.
  7. Select sales order query.
  8. From the left hand column select the selection folder and from the middle column find the name of the query you just made and drag it to Include records where.
  9. To find the date the order was completed- From the left hand column select sales order and from the middle column drag transaction date to results to display
  10. To add the constituents name- From the left hand column select constituent> from the middle column select name and drag it to results to display.
  11.  To get the total amount of the sales order-  From the left hand column select sales order> from the middle column select amount and drag it to results to display.
  12. To get the other price types associated with the order- From the left hand column expand Sales order item> expand sales order item ticket> expand program > select prices. From the middle column select price type and move it over to results to display.
  13. To see the price of each ticket> From the left hand column expand sales order item> Sales order item ticket> Select ticket and from the middle column select price and move it over to results to display.