GroupFooterExpression Property

Description

Gets or sets the expression used for calculations where GroupFooterType is set to DCFCalculated.

Property type

Read-write property

Syntax (Visual Basic)

Public Property GroupFooterExpression( _
   ByVal VarName As String _
) As String

Parameters

VarName: The variable name of the calculated data field.

Remarks

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

Example

[GroupFooterExpression property (Visual Basic)]

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

cityField.GroupFooterType("avgSales") = DCFCalculated

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