SSRS Report running Total using Expression?
Suppose we have One Parameter –> Balance = 100 and we needs to show running total on each rows as per example below. One of the way is that to write business logic in RDP class and calculate it. Other way is I have found a great method in SSRS EXPRESSIONS to do this work.
firstamt SecondAmt ThirdAmt RunningTotal
10 15 20 145
02 05 01 153
-30 -20 -03 100
SSRS EXPRESSIONS TO CALCULATE RUNNING TOTALS.
=RunningValue(Fields!FirstAmt.Value + Fields!SecondAmt.Value + Fields!ThirdAmt.Value
, Sum
, Nothing)
+ Parameters!Balance.Value
You may have to change Nothing
to a different Scope depending on how your table is set up, it can be your table group Id or Main table Id of SSRS Report.

This was originally posted here.
*This post is locked for comments