Running Value Function in SSRS

Running Value Function in SSRS

In many Reports you want to display running sum like

Suppose you have a column Hours in your Report and in the Next column of your report you want to 

show running total of Hours like Below

Hours  Total Hours

8                8

10              18

20              38

30               68  

40              108

For this add a new column in your table Name it according to your Requirement in my case i have given it Total Hours

Select the Text Box Under your Column Name

Right Click -Expression-

--Write Below Expression

=RunningValue(Fields!Hours.Value, Sum, Nothing)

Preview the Report You will get the above output

The Running Function will take the value Sum it if no value is there it will do nothing.

Note: The above example is for Sum you can perform Other Examples also using this Function.