Using the Script Sheet
Scripts provide you with a programmatic means of deriving field values. In the previous "Using the Param Sheet" subsection, an example script was described in which an exchange rate was applied to a currency field to print that field in another currency.
The following example shows the script for that currency conversion.
{!grand total} * {?exchange rate}
In this example, grand total is a summary field and exchange rate is the parameter. In the expression, one value is simply multiplied by the other. In the JADE Report Writer Designer application, the script facility enables you simply to point and click in order to build an expression. Alternatively, you can write and apply JADE code to derive a report field value.
The following subsections describe how to create and maintain script fields, and provide a single expression script as an example.
For details about writing more-advanced scripts, see Appendix A, "Using JADE Report Writer Scripts".
