The following article provides an example of how to create a report using the Report Wizard.
Report
The Room Nights & Revenue by Room Type Report tracks the room nights and revenue produced by each different Room Type at a property.
Header
Fields
Filter
Filter is based on Arrival Date and does not include CANCELLED and NOSHOW reservations.
Reservations.[Arrival Date] >= '{d|Date From:}' AND Reservations.[Arrival Date] <= '{d|Date To:}' AND Reservations.[Status] <> 'CANCELLED' AND Reservations.[Status] <> 'NOSHOW'
Columns
Group By
Order By
Room Nights & Revenue by Room Type Report
The report will now appear in the Report Wizard (Reports > Report Wizard) as well as the Custom Reports (Reports > Custom Reports).
