Expressions

When clicking on the Control Expression icon on the Layout screen of the View Designer wizard, or selecting to add an Expression in the Properties section of a control, the Expression builder screen opens. Fields and/or Controls can be used to build an expression on the selected control. The Build Expression wizard enables a user to build expressions that perform operations and return values. An expression can be a short expression that refers to a field object or a long expression that supports decision functions or formatting based on fields or other items.

  1. It is important to note that when adding an Expression to a control, the data type of the control should match the expression input.
  2. It is important to note the following when testing for [is empty] and [is not empty]:
    • When using View fields, numeric fields will never evaluate to "empty" as the default value is "0".
    • When using controls, the values will evaluate as expected