Reporting Services - RowNumber & RunningValue

In Reporting Services, if you want to display Record Number in your report you can use RowNumber Function.

From sample image below the first column (No.) is using RowNumber Function
Syntax
RowNumber(Scope)

Scope - Name of dataset, grouping, or data region



Specify Expression as following:-
= RowNumber("TravellingExpense")

* TravellingExpense is my dataset name



Another function is RunningValue

Syntax
RunningValue(Expression, Function, Scope)

Expression - The expression on which to perform the aggregation and cannot contain aggregate functions

Function - The name of the aggregate function to apply to the expression except RunningValue, RowNumber or Aggregate function

Scope - Name of dataset, grouping, or data region

Notice that I want running number of those different Initial Value (Same Initial will have same No.)



I can do that by right-click at Running Number cell -> select Expression...



Specify Expression as following:-
= RunningValue(Fields!Initial.Value, CountDistinct, "DetailIntercharge")

* DetailIntercharge is my dataset name



Further more, I do not want display duplicated Running Number.



Just right-click at Running Number cell again, select Properties



Check at Hide Duplicates and select Containing group or dataset to DetailIntercharge (your dataset)



That's all !!