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](https://media.screensteps.com/image_assets/assets/006/528/466/original/82a92d87-bbe2-401b-a9f9-e978867b707c.png)
Header
![Header](https://media.screensteps.com/image_assets/assets/006/528/468/original/38311d13-2569-4abf-a4c0-acd21110a899.png)
Fields
![Fields](https://media.screensteps.com/image_assets/assets/006/528/470/original/d1810f8c-6795-4647-b61c-a6ab509b4c3f.png)
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](https://media.screensteps.com/image_assets/assets/006/528/472/original/a89d918f-d699-4079-aba0-612a48a141a3.png)
Columns
![Columns](https://media.screensteps.com/image_assets/assets/006/528/474/original/be277ad8-e0cc-4764-a2e9-d2afa5d9d56f.png)
Group By
No particular Grouping is needed for this report, therefore this tab can be skipped.
![Group By](https://media.screensteps.com/image_assets/assets/006/528/476/original/a6c28094-9a52-4109-88e7-f3fc647cac44.png)
This report can be ordered based on the Vehicle License Plate Number to help with locating a specific License Plate.
![](https://media.screensteps.com/image_assets/assets/006/528/478/original/4a6e0b3d-910a-4dc1-8342-6869bc278640.png)
The report will now appear in the Report Wizard (Reports > Report Wizard) as well as the Custom Reports (Reports > Custom Reports).
![](https://media.screensteps.com/image_assets/assets/006/528/480/original/cdc59031-9c70-473d-a834-45132a3af999.png)