Support Centre

Report Example 3: Room Nights & Revenue by Room Type

Updated on

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.

Report
Header

Fields

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'

Filter

Columns

Columns

Group By

Group By

Order 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).

Room Nights &amp; Revenue by Room Type Report
Previous Article Report Example 2: Reservations By Clerk
Next Article Report Example 4: Transaction Code Usage
Have a question for us? Submit a Support Case