To report on the number of combinations sold:
  1. Go to the sales page and under reports click sales.
  2. Run the report for the date and payment method you want to report on.
  3. Click view report.
  4. Find the program you want to report on by scrolling through the report.
  5. Click the plus sign next you your program and the report will show the number of single tickets sold and the number and name of the combinations that have been sold.

If you need to report on combinations in a query, use one of the following two options:

The First option is use a sales order query to search for sales orders where someone bought tickets to both programs. However,  This may catch records where people simple bought tickets to both events without the use of the combination.  
  1. Go to Analysis > Information Library.  Click Add an ad-hoc query.  Choose sales order source view and click Ok.
  2. From the left hand column expand sales order item> sales order item ticket> program.
  3. From the middle column select program record and drag it to include records where, and set it equal to the first program in your combination
  4. From the left hand column expand sales order item> sales order item ticket> program.
  5. From the middle column select program record and drag it to include records where, and set it equal to the second program in your combination
  6. In Include Records Where, click on your first line of criteria and click the add left parenthesis button.
  7. In Include Records Where, click on your second line of criteria and click the add right parenthesis button.
  8. Go to Preview Results to see the number of sales orders where both programs were sold.
  9. Click on the row and click Browse to determine if it was a combination or someone simply bought both programs in the same sales order.
The second option is to query by price amount.  This method will only work if the price of the ticket for you event with in the combination cannot be achieved through any other discount.
  1. From the tickets tab, click on combinations under Discounts and promotions.
  2. Click on your combination.
  3. Under the program tab, pick the program you are trying to report on and make a note of the cost of the ticket.
  4. Go to Analysis > Information Library.  Click Add an ad-hoc query.  Select the source view of sales order and click OK.
  5. From the left hand column expand sales order item> sales order item ticket> program.
  6. From the middle column select program record and drag it to include records where, and set it equal to the program in your combination that got the price from in steps 3.
  7. From the left hand column expand sales order item> sales order item ticket> tickets.
  8. From the middle column select price and move it over to include records where.  Set the criteria to price is equal to and in put the amount you got in the step 3.  
  9. Go to Preview Results to see the number of sales orders with this program and price.
  10. Click on the row and click Browse to determine if it was a combination.