Udostępnij za pośrednictwem


RunningValue Function (Reporting Services)

Returns a running aggregate of the specified expression.

Syntax

RunningValue(Expression, Function, Scope)

Parameters

  • Expression
    (Data type is determined by the aggregate function specified in Function.) An expression that evaluates to numeric data on which to perform the aggregation. The expression cannot contain aggregate functions.
  • Function
    (Enum) The name of the aggregate function to apply to the expression. This function cannot be RunningValue, RowNumber, or Aggregate.
  • Scope
    (String) The name of a dataset, grouping, or data region that contains the report items to which to apply the aggregate function. If a dataset is specified, the running value is not reset throughout the entire dataset. If a grouping is specified, the running value is reset when the group expression changes. If a data region is specified, the running value is reset for each new instance of the data region. For more information about the Scope parameter, see Using Report Functions in Expressions (Reporting Services).

Return Type

Determined by the aggregate function that is specified in the Function parameter.

Remarks

Restrictions for RunningValue are also determined by the aggregate function specified in the Function parameter. For more information, see the topic for the aggregate function that you are interested in using.

The set of data specified in the expression must have the same data type. To convert data that has multiple numeric data types to the same data type, use conversion functions like CInt, CDbl or CDec. For more information, see Type Conversion Functions.

Scope cannot be an expression.

Example

The following code example provides a running sum of the cost field in the outermost data region.

RunningValue(Fields!Cost.Value, Sum, Nothing)

See Also

Concepts

Creating Expressions in Reporting Services

Help and Information

Getting SQL Server 2005 Assistance