0 out of 6 rated this helpful - Rate this topic

Aggregate Function (ReportViewer)

Visual Studio 2005

Returns a custom aggregate of the specified expression, as defined by the data provider.


Aggregate(Expression, Scope)

Expression: The expression on which to perform the aggregation. The expression must be a simple field reference.

Scope: (String) The name of a data table, object, grouping, or data region that contains the report items to which to apply the aggregate function. If Scope is specified, the aggregate function applies to all data in the data source, grouping, or data region. All group expressions for the specified scope must contain simple field references. For more information about the Scope parameter, see Built-in Functions for ReportViewer Reports.

Return type is determined by the data provider. Returns Nothing if the data provider does not support this function or data is not available.

All containing groups for the item that uses this function must have simple field references as their group expressions.

The following code example provides a custom aggregation of line item totals in the Order grouping or data region.

Aggregate(Fields!LineTotal.Value, "Order")

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)