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:

...

In expressions, script, or script blocks


Variable Type

Missing value treated as null

Missing value included

or

 Variables

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:

...