GroupFooterType Property

Description

Gets or sets the group footer type of a field.

Property type

Read-write property

Syntax (Visual Basic)

Public Property GroupFooterType( _
   ByVal VarName As String _
) As GroupFooterTypes

Parameters

VarName: The variable name of the field.

Remarks

When a GroupFooterType(x) is set to DCFCalculated the user can supply a formula using GroupFooterExpression(x). If the user does not specify a GroupFooterType, for a calculated field the default setting is sum. If a field is not calculated and a GroupFooterType is not specified, the GroupFooterType will be based on the fields AggregateFunc by default.

Example

[GroupFooterType property (Visual Basic)]

' show the [true average of sales] for all cities

cityField.GroupFooterType("avgSales") = DCFCalculated

cityField.GroupFooterExpression("avgSales") = "groupsum(sumSales)/groupsum(cntSales)"