There are times when you may want to see current orders for future events. Here are the parameters to configure a report to review orders for events in the future:
Date Field: Event Start Date
Date Range: Current Date - Desired End Date
Filter on: Transaction Type Contains Sales,RefundSales
Include the following data fields in the Grouping section of the report: Event Start Time, Event Name, Order Number, Billing First Name, Billing Last Name, Billing Email, Billing Phone
Optionally, you could include Ticket Type to the Grouping section as well and add Quantity to the Summarize section to see the contents of the orders
We recommend exporting the CSV to Excel or a similar program for easier analysis.
Here is what your final report will look like:
