​Option 1: Use the Zip Code Report filtered on a specific program or set of programs.
  1. Go to Sales and select ZIP code under Reports.
  2. For the Program filter dropdown, choose Specific program if you want to see Zip Codes for one program or Selected Programs if you want to see Zip Codes for a set a programs.
    1. If you choose Specific Program, click on the magnifying glass.  Then search for and select your program.
      • Note: If you are trying to report on Admission programs, mark the box to Include Daily Admission in the search window.
    2. If you choose Selected Programs, you will need to build a query selection of the programs you want to report on.  Click on the magnifying glass.
    3. Search for an existing program query or click Add to add a new query selection.
    4. If you click Add, select the source view of Program Query and click Ok.
    5. In the middle column of query, click Program record and move to Include Records Where.
    6. Set the criteria to One of and search for each program you want to report on.
    7. Click OK
    8. Go to the Set Save Options tab.
    9. Name the query.
    10. Click Save and Close.
  3. Select any other filters for your Zip Code Report and click View Report.
Option 2: If you need more information than the Zip Code Report provides, you can create a query to view more information.  We recommend using the report when possible for ease of use.

Begin your query:
  1. Navigate to Analysis, then select Information library.
  2. Click Add an ad-hoc query
  3. Select the source view of Sales Order and click OK
Add fields to Include records where:
  1. If looking for a particular time frame: In the left column, select Sales order. From the middle column, drag Order complete date into Include Records where. Set Equal to or between your date range.
  2. To see ticket sales from certain programs: In the left column expand Sales Order Item, expand Sales Order Item Ticket, and select Program. From the middle column, drag Program record to Include records where. Set Equal to your program choice. You can also choose "one of" if you are looking to see multiple programs.
  3. If you want to filter on a specific ZIP code: In the left column, select Sales Orders. From the middle column, drag ZIP into Include records section. Set Equal to, between, or one of and put in the ZIP codes you wish to include. 
Add fields to Results fields to display:
  1. In the Results fields to display area, highlight Lookup ID, and click the Red X above to remove the field.
  2. In the left column, select Sales Orders. From the middle column, drag ZIP into Results fields to display. 
  3. In the left column, highlight Sales Order Item. From the middle column drag Quantity into Results fields to display.
    • Note: we do not recommend using any SUM functionality on the Quantity field in Results fields to display, as it may inflate the number of tickets actually sold. Calculations should be done after the query is exported to Excel.
Save your query:
  1. Click the Set save options tab and Name the query
  2. Save and Close