Returns or sets the function to be used in calculating the value displayed by the Function control.
Syntax
object.FunctionType [=integer]
The FunctionType property syntax has these parts:
Part | Description |
object | Required. An object expression that evaluates to an object in the Applies To list. |
integer | Optional. A numeric expression that specifies the function, as shown in Settings. |
Settings
The settings for integer are:
Constant | Value | Description |
rptFuncSum | 0 | (Default) Sums the values of the DataField. |
rptFuncAve | 1 | Averages the values of the DataField. |
rptFuncMin | 2 | Returns the minimum value of the DataField. |
rptFuncMax | 3 | Returns the maximum value of the DataField. |
rptFuncRCnt | 4 | Counts the rows in the section. |
rptFuncVCnt | 5 | Counts the fields with non-null values. |
rptFuncSDEV | 6 | Calculates the standard deviation. |
rptFuncSERR | 7 | Calculates the standard error. |