texts

Contains options that specify text patterns for summary items.

Type:

Object

Depending on their type, summary items use one of predefined text patterns specified in the summary.texts object. For example, summary items of the 'avg' type use the pattern specified by the avg field of the texts object.

By default, a summary item is located in the column that provides data for it. This column is called the "parent column". However, a summary item may be located in any other column or in a group row. To specify text patterns for such summary items, use options with the OtherColumn addition in their name. For example, summary items of the 'avg' type located outside their parent column use the pattern specified by the avgOtherColumn field of the texts object.

When implementing a pattern, you can access the summary item value with applied format using position marker 0. If the summary item is placed outside its parent column, you can also access the caption of the parent column using position marker 1. Place each of these position markers within curly brackets.

avg

Specifies a pattern for the 'avg' summary items when they are displayed in the parent column.

Type:

String

Default Value: 'Avg={0}'

avgOtherColumn

Specifies a pattern for the 'avg' summary items displayed in a group row or in any other column rather than the parent one.

Type:

String

Default Value: 'Avg of {1} is {0}'
See Also

count

Specifies a pattern for the 'count' summary items.

Type:

String

Default Value: 'Count={0}'

max

Specifies a pattern for the 'max' summary items when they are displayed in the parent column.

Type:

String

Default Value: 'Max={0}'

maxOtherColumn

Specifies a pattern for the 'max' summary items displayed in a group row or in any other column rather than the parent one.

Type:

String

Default Value: 'Max of {1} is {0}'

min

Specifies a pattern for the 'min' summary items when they are displayed in the parent column.

Type:

String

Default Value: 'Min={0}'

minOtherColumn

Specifies a pattern for the 'min' summary items displayed in a group row or in any other column rather than the parent one.

Type:

String

Default Value: 'Min of {1} is {0}'
See Also

sum

Specifies a pattern for the 'sum' summary items when they are displayed in the parent column.

Type:

String

Default Value: 'Sum={0}'

sumOtherColumn

Specifies a pattern for the 'sum' summary items displayed in a group row or in any other column rather than the parent one.

Type:

String

Default Value: 'Sum of {1} is {0}'
See Also