Share via


CountRows Function (Reporting Services)

Returns the number of rows in the specified scope, including rows with null values.

Syntax

CountRows(scope, recursive)

Parameters

Return Type

Returns an Integer.

Remarks

CountRows counts all rows in the specified scope, including rows that have null values.

The value of scope cannot be an expression and must refer to the current scope or a containing scope.

Example

The following code example shows an expression that calculates the number of rows in a row group named GroupbyCategory (based on the expression [Category]).

="Number of rows: " & CountRows("GroupbyCategory")