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.
Header
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],'') = ''
Columns
Group By
The Group By tab can be left blank.
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).
