The following article provides an example of how to create a report using the Report Wizard.
NOTE: In order for this report to work, the property must have Custom Fields defined and in use. To set Custom Fields, proceed to System Configuration > Setup Custom Fields.
Report
This report is based on the Custom Fields found in the PMS (System Configuration > Setup Custom Fields). This particular report shows all the Custom Data for the arrivals of a selected date range.
Header
Fields
This filter searches for Arrivals for a selected date range, and will only show reservations where the Custom Fields are NOT blank.
Reservations.[Arrival Date] >= '{d|Date From:}' AND Reservations.[Arrival Date] <= '{d|Date To:}' AND (NOT IsNull(Custom Fields.[Anniversary],'') = '' OR NOT IsNull(Custom Fields.[Birthday],'') = '' OR NOT IsNull(Custom Fields.[Drivers License],'') = '' OR NOT IsNull(Custom Fields.[Passport Number],'') = '')
Columns
Group By
Order By
Custom Guest Information Report
The report will now appear in the Report Wizard (Reports > Report Wizard) as well as the Custom Reports (Reports > Custom Reports).
