Support Centre

Report Example 5: Unassigned Rooms Report

Updated on

The following article provides an example of how to create a report using the Report Wizard.

Report

The Unassigned Rooms Report can be used to assist in finding upcoming reservations that do not have a room number assigned.

Report
Header

Fields

Fields

Filter

This filter shows all reservations that do not have a Room Number assigned (it is looking for reservations where the Room Number is "Null" (ie: empty).

Reservations.[Status] = 'RESERVATION' AND  IsNull(Reservations.[Room],'') = ''

Filter

Columns

Columns

Group By

The Group By tab can be left blank.

Group By

Order By

Order By

Unassigned Rooms Report

The report will now appear in the Report Wizard (Reports > Report Wizard) as well as the Custom Reports (Reports > Custom Reports).

Unassigned Rooms Report
Previous Article Report Example 4: Transaction Code Usage
Next Article Report Example 6: VIP Arrival Report
Have a question for us? Submit a Support Case