FieldToAggregate Property

       

Returns or sets the name of the DEField object on which the aggregate is based.

Syntax

object.FieldToAggregate [=string]

The FieldToAggregate property syntax has these parts:

Part Description
object An object expression that evaluates to an item in the Applies To list.
string A string expression that specifies the name of the DEField object on which the aggregate is based.

Remarks

The valid fields that can be specified depend on whether the Command object is grouped or used in a relation hierarchy. If the AggregateType property is deGrouping, all the fields in the current DECommand object are available. If deGrandTotal and the Command object is grouped, only grouping fields are available; if not grouped all fields are available. If deRelation and the child DECommand object is grouped, only grouping fields are available; if the child is not grouped, all child fields are available.