Purpose
The Booking Export Report provides an extract of all bookings based on the location and date criteria provided when generating the report.
While this report can be exported in various formats, it has been designed primarily for use as a 'data dump' into an Excel Spreadsheet or .CSV file where the data can be further manipulated and analysed as required.
The report will include all fields for bookings in a status of Reservation, Hired or Returned.
After running the report, you have the option to:
- Hide / Show Columns -This is useful as this Report shows a lot of different fields, some of which you may wish to hide. Once these changes have been made, they will be replicated when exporting to Excel etc
- Print
- Copy results to clipboard - Allows you to copy and paste results to applications such as Microsoft Word
- Export to Excel
- Export to CSV
- Export to PDF
Accessing the Booking Export Report
To open the Booking Export Report follow the steps below:
Reports > Other Reports > Bookings Export
Parameters
After selecting the parameters, click "View" to run the report.
Example
Hide / Show Columns
As the report includes all relevant fields in the booking, the 'Hide/Show columns' feature allows you to hide any fields you do not wish to include in the export.
Print
After running the report, you have the option to print it straight from your browser. Click on the Print button.
Copy Results to Clipboard
Allows you to copy and paste results to applications such as Microsoft Word. Click on the Copy to Clipboard button.
Export to Excel
Click on the Excel button to export and view the report in Excel. Note that the report has been designed for Export and is best viewed in Excel.
Export to CSV
Click on the Export to CSV button to export and view the report in Excel. Note CSV files are file formats that contain plain text values delimited by commas.
Export to PDF
Click on the PDF button to export and view the report as a PDF. From here, you can also save and print the report.
Note that due to the large number of fields in this report, PDF is not the best option for viewing unless numerous fields have been hidden.