# 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](https://d3codex.com/attributedefiningitem/input-conversion/)
- [output-conversion](https://d3codex.com/attributedefiningitem/output-conversion/)
- [Processing codes overview](https://d3codex.com/processingcodes/processing-codes-overview/)
- [grand-total modifier](https://d3codex.com/access/grand-total-modifier/)

---
Source: https://d3codex.com/processingcodes/xr-running-subtotal-processing-code/ - part of the D3Codex reference.
