Reference: Field Options
When you create a report, you can specify these options for a field. Not every option is available for every field type.
Option | Field Types | Description |
|---|---|---|
[Analytic Indicator]
| All | Displays an analytic indicator next to the field.
This option is only available for fields with analytic indicators associated with them. To preview the analytic indicator definition, select the related actions menu for this option. |
Average
| Currency
Numeric | Calculates the average for the field and displays it in the subtotal or grand total line on the report. |
Display As Thumbnail
| Single Instance | Displays an image as a thumbnail.
This option is only available for fields with a related business object of Image. |
Display Field as Icon
| Text | Displays a speech bubble icon instead of the field value. You can view the field value by clicking the icon. |
Do Not Show if Empty
| All | Hides the column containing this field if all values are empty. |
Do Not Show On Worklet
| All | Hides the field if you deploy the report as a worklet. |
Maximum
| Currency
Numeric | Calculates the maximum value for the field and displays it in the subtotal or grand total line on the report. |
Minimum
| Currency
Numeric | Calculates the minimum value for the field and displays it in the subtotal or grand total line on the report. |
Related Tasks Only
| Single Instance
Multi-instance | Hides the field and displays the related actions menu for the field. |
Show No When False
| Boolean | Displays No when a Boolean value is false. If you don't select this option, false values display as blank. |
Show Blank When Zero
| Currency
Numeric | Displays a blank value if a numeric field value is zero. |
Show Currency Column
| Currency | Displays the currency code in a separate column on the report. |
Show Currency Symbol
| Currency | Displays the currency symbol. Example: $. |
Show Icon Only
| All | Displays the analytic indicator only and hides the field value.
This option is only available for fields with analytic indicators associated with them. You can only select this option on advanced reports. |
Show Report as Executable
| Single Instance | Displays the report name as a hyperlink that you can click to run the report.
This option is only available for the custom report name field. |
Sum
| Currency
Numeric | Displays the sum of all values for the field in the subtotal or grand total line on the report. |