Dynamic Template Function Configurations
Prerequisite:
See Add Fields and Methods to a Dynamic Template.
A variety of Oracle built-in functions can be applied to report template fields. These functions are grouped into the following sub-categories.
Note:
Nested functions are only supported within a function sub-category. Nesting of functions across sub-categories is only supported for the NVL function.
To apply a function to a field, take the following steps.
In the Dynamic Template Designer, select a field in the Selected Fields list at the right of the Dynamic Template Designer window.
Click at the bottom of the Dynamic Template Designer, to launch the Function Builder window.
A drop-down list of functions lets you select the function to be applied to the field.
Click to view the drop-down list of available functions.
Select a function from the list.
Certain functions, such as DECODE, require parameters. A configuration window will display when parameters need to be configured.
Enter values or fields in the Function Details window, as shown in the following DECODE example.
Note that as you configure function parameters, the syntax will auto-complete at the top of the Function Details window so that you can view how it will be implemented.
