Friday, April 30, 2010

Add Row Number to a SQL Report contains Groups

We can add row number to a report which has groups by adding below expression to Row Group of the Row Number column

= RunningValue(Fields!CountColumn.Value, CountDistinct, "MyDatasetName")

To add Row Number to the Details Group, select the field of the Row Number in the Details Group and add the below expression.

= RowNumber(Nothing)


1 comment: