...
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:
<%= #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:
...