Support CentreStandard ModulesReports Report WizardReport Example 1: In House Guest License Plate Report

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

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.

Report
Header

Fields

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], ' ') = ' ')

Filter

Columns

Columns

Group By

No particular Grouping is needed for this report, therefore this tab can be skipped.

Group By

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).