Report Example 1: In House Guest License Plate Report
The following article provides an example of how to create a report using the Report Wizard.
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.
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], ' ') = ' ')