A Function control displays figures calculated at run time using various built-in functions.
Syntax
rptFunction
Remarks
The functions contained by the Function control include:
Function | Description |
Sum | Sums the values of a field. |
Min | Displays the minimum value of a field. |
Max | Displays the maximum value of a field. |
Average | Displays the average of values. |
Standard Deviation | Displays the standard deviation for a column of figures. |
Standard Error | Displays the standard error for a column of figures. |
Value Count | Displays the number of fields containing non-null values. |
Row Count | Displays the number of rows in a section of the report. |
The Function control can only be placed in a group footer section of a Data Report designer.
The Data Environment also features an aggregate field that has some similar functions as the Function control.