Note: The Expression Builder has been updated. However, the deprecated Expression Builder opens from the check box control.
There are two function builders which provide guided interfaces to help the user construct sound Java and SQL expressions. The information below covers creating Java expressions. For information on SQL functions see Report Definitions — Using the Calculation Builder.
You can type an expression into a field, or use the deprecated Expression Builder to guide your selection and check your work. The Expression Builder helps you locate functions and complete parameters to functions in a natural language format. From the full Expression Builder form, click:
You can enter all or part of the expression in the large text area by typing, including functions, operators, constants, and property references or linked property references. .
To include a function in your expression, select a library from the list that is likely to contain the desired function. The form changes to list the functions in that library and the parameters for each function.
The selection area lists the functions in the selected library alphabetically, with a description of each.
If the selected function requires arguments, you are prompted for each argument value. (Output arguments are listed without a place for input.)
If you don't yet know the property, expression, function, or other value, enter a constant for the argument.
Click Insert to insert the function call and your arguments into the expression.
Click Validate to check the syntax of the expression. (This does not check whether properties you reference in the expression are defined.)
Click Cancel to close the form and return to the previous form without changes.
When an expression is complete and valid, click Save .