The following aggregate functions are available:
| Function | Examples | Description |
|---|---|---|
| Count( expression[, scope[, query]] ) | Count( Fax ) or Count( * ) | Counts all of the non null items of expression. Use a "*" for counting all items of the record set. |
| Sum( expression[, scope[, query]] ) | Sum( LineTotal ) or Sum( Multiply( UnitPrice, Quantity ) ) | Sums all of the expression values. |
| First( expression[, scope[, query]] ) | First( Fax ) | Returns the first expression value of all items of the record set. |
| Last( expression[, scope[, query]] ) | Last( Fax ) | Returns the last expression value of all items of the record set. |
| Mean( expression[, scope[, query]] ) | Mean( Quantity ) | Returns the average of all of the expression values. |
| Median( expression[, scope[, query]] ) | Median( ProductName ) | Returns the median expression value. |
| Mode( expression[, scope[, query]] ) | Mode( Marks ) | Returns the least most frequent expression value. |
| Max( expression[, scope[, query]] ) | Max( Quantity ) | Returns the maximum expression value. |
| Min( expression[, scope[, query]] ) | Min( Quantity ) | Returns the minimum expression value. |
| StDev( expression[, scope[, query]] ) | StDev( Quantity ) | Returns the standard deviation of a numeric expression evaluated over a set. |
Aggregate functions can contain optional scope (scope) and query (query) values. The scope must be equal to the ID of the report or any sub report within the report. The Query value must be equal to the ID of any query within the report or sub report.
| See Also |
Functions | Dictionaries | Expressions | Programming with ReportWriter for .NET