Udostępnij za pośrednictwem


Previous Function (Reporting Services)

Returns the previous instance from the specified scope.

Syntax

Previous(Expression)

Parameters

  • Expression
    (Variant or Binary) The expression on which to perform the aggregation. The expression cannot contain aggregate functions. Not supported in chart or matrix data regions.

Return Type

Returns a Variant or Binary.

Description

The following code example provides the value for the field LineTotal in the previous row of a table or list data region. The value is Nothing for the first row.

Code

Previous(Fields!LineTotal.Value)

See Also

Concepts

Creating Expressions in Reporting Services

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

14 April 2006

Changed content:
  • Updated parameter list by removing AggFunction, Scope, and AggScope.