xr (Running Subtotal) Processing Code

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

See Also

input-conversion

output-conversion

Processing Codes Overview

total Modifier