Udostępnij za pośrednictwem


RowNumber Function (Reporting Services)

Returns a running count of all rows in the specified scope.

Syntax

RowNumber(Scope)

Parameters

  • 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

Returns an Integer.

Remarks

Scope cannot be an expression.

Example

The following code example provides a running count of rows in the outermost data region.

RowNumber(Nothing)

See Also

Concepts

Creating Expressions in Reporting Services

Help and Information

Getting SQL Server 2005 Assistance