Report Expression Editor Definitions

This section shows the Data Model being used for this report. Clicking on the main folder will display all Fields and Internal Fields from the parent entity along with folder(s) for the child entities that can be applied to the report.

There are four folders available for Expression Functions. To access choices associated with a particular folder, click the "+" to display the child options associated with the parent folder.

Folders

• SmartSolve - Use this folder to build expressions based on current users, to strip HTML tags or to translate strings.
• Hyperlinks - Use this folder specify a SmartSolve URL, a URL to launch a report or a URL for a current application. You can also specify various other SmartSolve Detail Pages such as; Internal Actor, Audit, Criteria, etc.)
• Operators - Use this folder to apply algebraic functions such as arithmetic, comparisons, concatenations, and logic expressions.
• Common Functions Use this folder to build expressions with common functions such as: Text, Date & Time, Math, Inspection, Program Flow, Aggregate, Financial, Conversion, Colors, as well as other miscellaneous functions.

Expressions are added to the workspace at the bottom of the Expression Editor window. To select operations and data values, find the desired item in the list and double click it to transfer it to the Expression workspace.

Below are descriptions of actions performed when clicking on the buttons located at the bottom of the Expression Builder window.

• Check Syntax Click this button to verify that the syntax of the expression is error free. If there is an error with the syntax a Syntax Error will display.
• Save and Close Once the Expression has been added, click the Save and Close button to save the expression and return to the report design canvas.
• Cancel and Close Click this button to cancel the expression build process and return to the report design canvas.