Customer Registration by Event and Date Range Query (Demographics)

This query returns a list of customer event registrations by date range with demographics.

Query Parameters

Parameter	Description
Event Is Equal To	Select an event from the drop down list.
Registration Date Greater Than or Equal To	Enter a date, or select a date from the drop down calendar, for the query.
Registration Date Less Than or Equal To	Enter a date, or select a date from the drop down calendar, for the query.

Query (Default) Fields

Field	Description
Query Header	Displays the query name, number of records returned, and the total number of pages for the query.
Registration Date	Lists the customer registration date.
Badge First, Last, Name	Lists the customer badge first, last, and full name.
reg_special_instructions (multiple...)	TBD
reg_custom_date_01 (multiple...)	TBD
reg_custom_currency_01 (multiple...)	TBD
Currency 2	TBD
Integer 2	TBD
String 1 (10)	TBD
String 2, 4	TBD
reg_custom_text_01 (multiple...)	TBD
Text 2	TBD
Registrant Type Code	Lists the registrant type code.
trx Type	Lists the transaction type.
trx Amount	Lists the transaction amount.
trx Total Amount	Lists the transaction total dollar amount.
trx Add Date	Lists the transaction add date.
Prefix, First, Last, Middle Name, Suffix	Lists the registrant first, last, and middle name with any prefix or suffix.
Designation	TBD
Age, Gender	Lists the registrant age and gender.
Event Product Name	Lists the event product name.
Date	Lists the event date.
Order Number	Lists the associated order number for the event.
Order Status	Lists the associated order status.
Billing Address Line 1, 2, 3, City, State, Postal Code, Country	Lists the registrant billing address.
Event Fee Name	Lists the event fee name.
Phone Number	Lists the registrant phone number.
E-Mail Address	Lists the registrant email address.
Fax Number	Lists the registrant fax number.