The following article provides an example of how to create a report using the Report Wizard.
Report
The VIP Arrival Report will show a list of all arriving VIP Guests.
Header
Fields
Filter
The filter set is to find all the VIP Arrivals for a specific date, as opposed to a date range.
Reservations.[Arrival Date] = '{d|Select Arrival Date:}' AND Reservations.[Status] <> 'CANCELLED' AND Reservations.[Status] <> 'NOSHOW' AND Guests.[vip] = '1'
Columns
Group By
This report does not require grouping of any kind.
Order By
VIP Arrivals Report
The report will now appear in the Report Wizard (Reports > Report Wizard) as well as the Custom Reports (Reports > Custom Reports).
