The following article provides an example of how to create a report using the Report Wizard.
Report
Report Objective: This report provides the Vehicle Make, Model & License Plate Number for all In-House Guests.
NOTE: For this report to work, Vehicle Make, Model and License plate info will need to be entered on the Guest Info Tab for all guests in house.
Header
Fields
Filter
This report will search for In House guests only.
To do this, the filter expression must be set as Reservations.[Status] = (equals) 'Value'
RESERVATIONS.[STATUS] = "INHOUSE"
NOTE: To have the report only return guest records that have a License Plate, and omit those that do not, use this in the filter: (NOT ISNULL(GUESTS. [VEHICLE LICENSE], ' ') = ' ')
The resulting filter would be:
RESERVATIONS. [STATUS] = ' INHOUSE' AND (NOT ISNULL(GUESTS. [VEHICLE LICENSE], ' ') = ' ')
Columns
Group By
No particular Grouping is needed for this report, therefore this tab can be skipped.
This report can be ordered based on the Vehicle License Plate Number to help with locating a specific License Plate.
The report will now appear in the Report Wizard (Reports > Report Wizard) as well as the Custom Reports (Reports > Custom Reports).
