Grid Totaling XML

An XML  string property that is used to set up and enable totaling in the column footers and/or group totals.  The property should include a root node value of Totaling with Item child node values representing each totaling value to display.

AggregateFunction

The type of totaling function to perform.

Options: Avg, Count, Max, Min, Sum

ColumnMember

The string value of the name of the column member to perform totaling on.

FooterText

The text that will be displayed in the column footer.

GroupRowInfoFormat

Sets the string format of the group row.

GroupTotalVisible

A Boolean value that enables the group row total.

Example:

          <Totaling>

<Item>

<GroupRowInfoFormat>[value]: - Rows [count] || Sum of ListID = [sum(ListID)]</GroupRowInfoFormat>

<ColumnMember>Priority</ColumnMember>

</Item>

<Item>

<GroupRowInfoFormat>[value]: Count [count] - Avg [avg(ListID)]  Sum [sum(ListID)]</GroupRowInfoFormat>

<ColumnMember>Assigned To</ColumnMember>

</Item>

<Item>

<ColumnMember>ListID</ColumnMember>

<AggregateFunction>sum</AggregateFunction>

<FooterText>Sum:</FooterText>

</Item>

<Item>

<ColumnMember>ListID</ColumnMember>

<AggregateFunction>sum</AggregateFunction>

<FooterText>Sum:</FooterText>

</Item>

</Totaling>

Back to Top