...
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 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 |
---|
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:
...