Support CentreStandard ModulesReports Report WizardReport Example 8: Custom Fields Report

Report Example 8: Custom Fields Report

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.

Report
Header

Fields

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

Columns

Group By

Group By

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

Custom Guest Information Report