Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Aggregate Function (Reporting Services)

Updated: 15 September 2007

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

Aggregate(Expression, Scope)


An expression that evaluates to numeric data on which to perform the aggregation. The expression must be a simple field reference.


(String) The name of a dataset, 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 dataset, grouping, or data region. All group expressions for the specified scope must contain simple field references. For more information about the Scope parameter, see Using Report Functions in Expressions (Reporting Services).

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 difference between the Aggregate function and the Sum report functions is that the aggregated values are calculated in the data processing extension and returned as part of the dataset, whereas the Sum function processes the contents of detail rows and calculates the result.

Scope cannot be an expression.

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

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

Release History

14 April 2006

New content:
  • Description of the difference between Aggregate and Sum functions.

Community Additions

© 2015 Microsoft