Dot Net: Adding Serial Numbers in the RDLC Report

Hi Friends i think every one know how to place the serial number in the rdlc report.

=RunningValue(Fields!YOURCOLUMNNAME.Value,CountDistinct,Nothing)

This will Display the serial Numbers like

S.NO NAME REGION TARGET

1 RAM ANDHRA 13000

2 MAHI TELANGANA 15000

3 KISH RAYALASEEMA 13500

4 SAI TELANGANA 15500

5 KRTH ANDHRA 32000

6 MANI RAYALASEEMA 16500

7 RAJ TELANGANA 36000

8 MANISH TELANGANA 12500

To Display the Serial Numbers according to Region wise like

SNO NAME TARGET

1. ANDHRA

1.1 RAM 13000

1.2 KRTH 32000

2.RAYALASEEMA

2.1 KISH 13500

2.2 MANI 16500

3. TELANGANA
   3.1    MAHI            15000
   3.2    SAI                15500
   3.3    RAJ                36000

3.4 MANISH 12500

To Print the Above Format Just make a group and add the following Formula in the following way.

=RunningValue(Fields!YOURCOLUMNNAME .Value,CountDistinct,Nothing) & "." & RowNumber("table1_Group1")

Dot Net