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:

OPTION #1: Use a selection within a sales order query to search for sales orders where someone bought tickets to both programs. However, keep in mind this may catch sales orders where people simply bought tickets to both events in the same order, without the use of the combination.
 
Step #1: Create the first 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
  4. In the left column, expand Sales Order Item, expand Sales Order Item Ticket, then select Program. From the middle column, drag Program record into Include records where. Set Equal to one of the combination's program records.
  5. Click the Set save options tab and Name your query
  6. Mark to Create a selection
  7. Mark to Show this Selection in the Query Designer
  8. Save and Close
Step #2: Create the second 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
  4. In the left column, expand Sales Order Item, expand Sales Order Item Ticket, then select Program. From the middle column, drag Program record into Include records where. Set Equal to one of the combination's program records.
  5. In the left column, expand Selections. From the middle, drag your selection from step #1 above into Include records where. Set Equal to Yes.
  6. Click Set save options tab and Name your query
  7. Save and Close
Example of your final query:
User-added image

OPTION #2: 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.