summary 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}'

    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}'

    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}'