Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This page has advanced features that require a knowledge of JavaScript.  The scripting is done in the Script window accessed through the Edit Script button Image Added of the Report Template Update page.

Details

In expressions (created by using Expression dialog or using <%= %> syntax in the template) the following short-hand is allowed to reference variable values:

<%= #code %> -   results in the variable's value or blank if the value is null.

<%= #code1 + #code2 %> -    if the values are numeric, will result in the two numbers being added together, otherwise the two values will be concatenated together.

...

In expressions, script, or script blocks


Variable Type

Missing value treated as null

or

Variables without a missing value definition

Missing value displayed

Numeric#code.displayValue.value#code.value.value
Numeric calculation#code.displayValue.value

Categorical value (e.g. 0, 1)

(radio button or picklist)

#code.displayValue.value#code.value.value

 Categorical name (eg. no, yes)

(radio button or picklist)

#code.displayValue.name #code.value.name
Date

To display a date: #code.displayValue.toString()

To use a date in a calculation: #code.value.value


Text / memo#code.displayValue.toString()
Checkbox#code.value.value




#code.displayValue.toString() displays:

...