The reporting tool accesses a separate database in the background, in which the pre-calculated data is imported and updated once a night. The tool is set up and configured separately to your account. ## Step 1: Query Create a query in the query editor: - Table booking: All information on a booking / transaction / individual sale - booking_items + booking_payments: Individual listing of items - One item per line. If this table is not selected, one item is output per transaction - customer: Customer data such as address, zip code, city - fields: The individual fields are selected here and provided with an alias if necessary - sequence: Define the column sequence for the reports based on this here note: If buchungung_positionen is selected, one line is output per invoice item. If only the table buchung is selected, one row per transaction is output in the query result. ## Step 2: Report Create a report, i.e. a view based on the previously created query - Filter: Here you define your own filter criteria. For date values, use > (greater than) and < (less than) to narrow down a date range. For text values use `like`. - Sorting: Here you determine the order (sorting) for the output of the content. - SQL (optional - professional setting): Add your own criteria as an SQL command to the Where area of a query.