User Defined Function Editor Properties
This topic describes how you can use the User Defined Function Editor dialog box to write a user defined function that you can call in dynamic formulas or other user defined functions.
Server displays the dialog box when you expand the Dynamic Resources > User Defined Functions node in a resource list, then select <Add Function…>, or right-click a user defined function and select Edit from the shortcut menu in the Resources panel of Web Report Studio.
Function Name
Specify the name of the function.
Fields box
Server displays a list of fields that are available to functions. The fields include the group, detail and aggregation objects in the current business view, and the dynamic formulas and aggregations that you have created in the report. You can select one field and double-click it to insert the field into the editing box at the insertion point.
Functions box
Server displays a list of the Report built-in functions and user defined functions that are available to functions. When you select one function and double-click it, Report will insert the selected function into the editing box at the insertion point completely with its required syntax items (such as parentheses and commas).
Operators box
Server displays a list of operators that are available to functions. Select one operator and double-click it to insert the selected operator into the editing box at the insertion point.
Editing box
In this box, you can build and edit your function. You can use these ways to work with functions:
- Select function items from the Fields, Functions, and Operators boxes, and then double-click the items, Report will then insert them in the function.
- Type your function in the editing box directly.
- Paste function text from the text document of other programs.
Test Syntax button
Select to test the syntax of your function. If the syntax is incorrect, Report provides an opportunity to correct the errors.
Operator button
Select to insert a general operator into the function.
Color button
Select to open a color palette. Then, you can select a color from the color palette to insert its HEX code into the function, instead of typing the HEX code manually.
OK
Select to create or update the function and close the dialog box.
Cancel
Select to close the dialog box without creating or updating the function.
Help button
Select to view information about the dialog box.
Close button
Select to close the dialog box without creating or updating the function.