On the User-Defined Column Details page for a report, you can create up to 20 report columns based on fields in your event.
Each user-defined column can be one of two types.
- First non-blank value from up to three different columns with a default text label.
- A combination of multiple columns.
Click Add New to create a new user-defined column.
The existing custom columns are listed in a table. Click a custom column to edit it. Click to delete a custom column.
The custom columns added here are available on the Columns page to add to the report.
User-Defined Column
Column Name
Column Name is the name of the column as it should appear in all report screens.The maximum length is 25 characters.
Column Definition
Column Definition is the section where you specify which Certain field(s) will make up a user-defined column.Column Definition also supports creating a column that consolidates several columns into a single column in the report output.
Column Definition saves steps of merging cells in a separate application. Column Definition lets you select from the same fields that appear on the Groups page for the report.
A custom column is defined as a database field or free-text. A custom column is also defined as multiple columns combined into a single column.
Display the first non-blank from
Display the first non-blank from is an option with 3 drop-down lists plus a free-text field.Select this option if the custom column pulls from one or more Certain fields. Display the first non-blank from returns the first non-blank value for each record in the specified order.
If no value exists for a record in the specified field, you can enter a label in the free-text field. The free-text field label displays in the report instead of an empty cell. Example labels include '[blank]' or 'missing'.
Example: State/Province or: Province/District or: City or: [blank]This example column would return:
- State /Province for records that have a value for that field
- Province/District for records that do not have a State /Province
- City for records that have neither State /Province nor Province/District
- the text '[blank]' for records that do not have values for State /Province, Province/District, or City
Combine two or more columns
Combine two or more columns is an option to combine two or more Certain columns into a single report column.For example, Combine two or more columns can list registrant's full name in a single column. You can do this by first selecting Prefix in the drop-down list and clicking Append. Then you can select First Name and click Append. Then you can select Last Name and click Append. Then you can select Suffix.
The field below the Append section will show:
<{Prefix}><{First Name}><{Last Name}><{Suffix}>
You can add spaces between fields for proper formatting.
> Note: A user-defined column must have at least one column selected or at least one character entered in the free-text form field. > Once the user-defined column is created it can be added to the report in the Reports > Columns page.