Data Access

• Database Queries
  • Criteria Operators
  • Sample Mail List Queries
  • Criteria (Search) Window
  • Criteria Add/Edit Parameter Window
  • Criteria Conditions
  • Saved Criteria Window
• Data Imports & Exports
  • Data Exports
    • Data Export Locations
    • Specialty G/L Export Formats
  • Data Imports
    • Data Import Wizard
    • Special Import Column Names
• Mail Lists
  • Mail List Detail Window
  • Mail List Search Window
• Reports
  • Report Library
    • Attendance and Front of House
    • Box Office Statistics
    • Calendar and Facility Management
    • Course Reports
    • Donation Reports & Tax Receipts
    • Exporting, Labels & Record Counts
      • Record Count
      • Mailing Labels
      • Export Data
    • Online Forms and Responses
    • G/L Reports
      • G/L Budgets
      • G/L Budget VS Actual
    • Mail List Reports
    • Miscellaneous Reports
    • Orders & Payments
    • Pass, Membership, and Gift Certificate Reports
      • Pass/GC Detail - Year
      • Pass/GC Detail - Type
      • Pass/GC Cards
      • Pass/GC Type List
      • Pass/GC Summary - Remaining
      • Pass/GC Detail - Complete Information
      • Pass/GC Summary
      • Pass/GC Detail - Type Remaining
      • Pass/GC Detail - Pass/GC
    • Patron Reports
      • Patron List - Email Address
      • Patron List - Marketing Fields
      • Patron List
      • Media Detail
      • Patron List - Greeting & Formal Name
      • Patron Web Usage Statistics
    • Resource Reports
      • Resources Shipping Manifest - Resource
      • Resources Shipping Manifest - Patron
      • Resources Sold - Resource
      • Resources Sold - Patron
    • Sales Summary Analysis
      • Sales Detail - YTD Comparison
      • Sales Detail
      • Sales/Exchanges/Refunds - YTD Comparison
      • Sales/Exchanges/Refunds
    • Season Subscription and Subscription Packages
      • Season Package - Renewal Progress Statistics by Sub
      • Season Ticket Renewal Notice
      • Season Subscription - Change Requests
      • Season Subscription - Auto Renew Payment Methods
      • Favorite Seat List
      • Season Package - Event Listing
      • Season Package - Summary Listing
      • Season Package - Renewal Progress Statistics by Seat
      • Favorite Seat List with Address
    • Ticket Printing, Invoicing & Inventory Analysis
      • Revenue Summary for Royalty - Ticket Based
      • Tickets Sold by Price Code and Promotion
      • Revenue/Attendance Counts - Quick
      • Revenues by Payment Method - Deposit Based
      • Revenues by Payment Method - Ticket Based
      • Promoter Revenue Audit
      • Potential Revenue from Unsold Tickets
      • Tickets Sold by Price Code
      • Cash Flow - Ticket Inventory Analysis
      • Cash Flow - Transaction Analysis
      • Revenue Summary for Royalty - Quick
      • Revenue/Attendance Counts - Ticket Based
      • Tickets Sold/Revenues by Promotion & Price Code
      • Revenues by Promotion (Detailed Breakdown)
      • Tickets Sold/Revenues by Promotion, Price Code & Base Price
      • Revenues by Price Code & Promotion
      • Revenues by Promotion (Average Ticket Prices)
      • Tickets Sold/Revenues by Why Did Patron Buy
      • Revenue Summary for Royalty - Credit Card Discounts
      • Print Raffle Tickets
      • Revenue Summary - Quick
      • Print Invoices
      • Ticket Hold Counts - Quick
      • Ticket Held Seat Detail
    • Transaction History Reports
      • Transaction Revenues
      • Transaction History - By Order
      • Transaction History - By Sales Promotion Group
      • Transaction History - By G/L Journal #
      • Transaction History - By G/L Journal # (Totals Only)
      • Transaction History - By Series and Promotion (Totals Only)
      • Transaction History - By Order (Totals Only)
      • Transaction History - By Sales Promotion Group (Totals Only)
      • Transaction History - By Employee
      • Transaction History - By Employee (Totals Only)
      • Transaction History - By Event and Price Code (Totals Only)
      • Transaction History - By Patron (Totals Only)
      • Transaction History List
      • Transaction History - By Series and Promotion
      • Transaction History - By Event (Totals Only)
      • Transaction History - By Patron
      • Transaction History - By Event and Price Code
      • Transaction History List (Totals Only)
      • Transaction History - By Event
    • Utility Functions and Database Analysis
      • Check Transaction and G/L Entry Balances
      • Check Seat Transaction Balance by Performance
      • Check Web Cart and Final Order Status
      • Check Ticket Transaction Balances
      • Check Order and Transaction Balances
    • Volunteer and Volunteer History
      • Volunteer Schedule by Patron
      • Volunteer Hours Summary
      • Volunteer Award Detail
      • Volunteer Hours Worked by Perf Type
      • Cast & Crew Listing
      • Volunteer Schedule by Performance
      • Cast & Crew Program Insert
      • Cast & Crew Listing (Without Addresses)
      • Volunteer Code List - Summary by Patron
      • Volunteer Statistics
      • Volunteer Detail for a Patron
      • Volunteer Code List - Detail by Patron
      • Volunteer Code List - Volunteer in Each Code
      • Volunteer History List - Activity & Comments by Patron
      • Volunteer Time Availability by Patron
  • Custom Report Categories
  • Invoice Comments
  • Report Selection Window
  • Queued Reports
  • Finished Report Window
  • Invoice Build Options Tabs
  • Custom Reports
  • Sample Reports
  • Report Build Options Tabs
• REST API and Reveal
  • REST API
    • REST API Query Parameters
    • REST API Endpoint Columns
    • Sample REST API Queries
  • Reveal