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:

Getting Error Description and Error Column Name in SSIS 2016...

If you check the Error Output Path of a SSIS Data Flow component, it only contains the ErrorCode and the ErrorColumn (actually this the I...