Processing Codes
xr (running subtotal) processing code
.mdThe xr processing code produces a running subtotal of an output column on an AQL listing or report.
The attribute definition must have xr specified as an output-conversion (attribute 7) only. In order to get a running total, the attribute containing the xr conversion code must be totaled. If not, the conversion has no effect.
| System Processors | Select, List |
| Code Type | Attribute Defining |
| Dictionary Attributes | Output Conversion |
Syntax
xr{break.level}
Parameter(s)
| break.level | Specifies the control break level for a running subtotal. |
CAUTION: This processing code is only effective
from AQL. For compatibility reasons, a subvalue mark is allowed before
the break level.
Example(s)
Assume that the processing code below was present in the output-conversions of the attribute-defining item myattr:
xr1
This causes any AQL statements using this attribute in a total clause to reset the running total to 0 after the first and higher break levels.