Function Control (Data Report Designer)

               

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.