Export (0) Print
Expand All

Previous Function (Reporting Services)

Updated: 14 April 2006

Returns the previous instance from the specified scope.


Previous(Expression)

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.

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)

Release History

14 April 2006

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

Community Additions

ADD
Show:
© 2014 Microsoft