Serial Number to be given with grouping in Report Viewer

Serial Number to be given with grouping in Report Viewer

We could achieve this requirement in RDLC report, please follow these detailed steps to make it:

1. Right-click the whole matrix  control, and then select Properties.
2. Switch to Groups tab, click Add button to add another Row group, in the expression textbox, please select groupedcolumn1 datafield(This is very important)
3.  Then click the new row group, then click Up button to move it to the top1 location.
4. Click OK
5. Switch to the report’s design surface, then type in the expression =Runningvalue(Fields!GroupColumn1Name.Value,countdistinct,"MatrixName") in the textbox created in step3.

Note: In the expression, Please make sure the datafield name in the group1(Fields!GroupColumn1Name) and Matrix name(MatrixName) is correct.

Preview the report, you will get another column in left to display 1, 2, 3, 4, ……

ex:  =Runningvalue(Fields!InvoiceNo.Value,countdistinct,"Tablix1")

OR

=RunningValue(Fields!GroupName.Value, countdistinct,Nothing)