Name
|
All
|
The default database name.
|
Display Name
|
All
|
Appears as the column header for the field on the Filter page when generating a report. Click the pencil icon to edit the Display Name.
Note
|
-
Supports only alphanumeric characters.
-
The pencil icon is visible only on the first row of the parameter list.
-
For the subsequent rows, the pencil icon is visible when you hover over the Display Name.
|
|
Description
|
All
|
Enter the field description.
|
Data Type
|
Formula
|
Choose the data type for the field from the list. Available Data Types are: DECIMAL, STRING, NUMBER, DATE, DATETIME, and BOOLEAN.
This setting determines the options that are displayed for this field on the Fields tab.
|
Data Clause
|
Query and Filter fields only
|
Identifies which column in the data set is bound to this field. The SQL Parser uses this value when retrieving data from the
database.
Note
|
For Filter fields, specify the data clause. For Query fields, this value is auto populated from the query.
Data clause is limited to a maximum of 1000 characters (including whitespace).
|
|
Value List
|
Query and Filter fields only
|
Click the plus icon in the Value List column. In the Attach Value List window, select or type the appropriate values for the following fields. For more information, see Associate Value Lists.
When a field is associated with a Value List, report users can filter the report with one or more fields from that Value List
or its Collections.
Note
|
Only fields of type String and Decimal can be associated with a Value List.
|
|
Format | Footer
|
Query and Formula fields only
|
Click the pencil icon to edit the formatting for the field and the footer.
-
Format—Provides a list of default formatting masks. The available formats depend on the data type. For example, for Numeric values, you can select all possible display formats. For Custom selection, you can enter the format in the Custom Format text box.
-
Footer—The formula to use in the footer. Options are None, Average, Sum, Count, Minimum, and Custom Formula. The available options
depend on the data type.
Note
|
For footer formulae, ensure to apply aggregate functions to the columns. For example: SUM(${Field1})/(SUM(${Field2})+SUM(${Field3}))
|
For the Custom footer, the following fields appear:
-
Default Custom Footer Formula—Enter the footer formula to be applied when columns are grouped. This column does not have a custom footer formula defined
for that level.
-
Group 1 Custom Footer Formula—Enter the footer formula to be applied if this column is in the first level of grouping.
-
Group 2 Custom Footer Formula—Enter the footer formula to be applied if this column is in the second level of grouping.
-
Group 3 Custom Footer Formula—Enter the footer formula to be applied if this column is in the third level of grouping.
|
Allow to show if invisible
|
Query and Formula fields only
|
Uncheck this check box to hide from the Available fields panel. Check for the field to appear (retain) on the list of Available fields in the Grid Editor.
|
Available in Filter
|
All
|
Check to add the field to the Field Filters tab while choosing filters.
|
Select from Available Fields
|
Formula
|
Select a field from the list and click the arrow button to insert it into the Formula Syntax field.
Note
|
Fields on this list appear by Name and not by Display Name.
|
|
Formula Syntax
|
Formula
|
Displays operators that construct a formula for the fields you have selected. For more information, see Formula Creation Guidelines.
|