Make SUM column values ​​of the entire row to the current row in SSRS

Question

I have a web application with SSRS reports ...

I have a situation where I have to update the sum of a specific field in the last column for the entire row above the current row.

eg..

ID Balance Total ---------------------- 1 100 100 2 200 300 3 10 310 4 -100 210 5 200 410 

In the table above, the last column of Total is the sum of the value of the Balance column of all the above rows. how can i achieve this

Thanks..

Answer 1

You can use the RunningValue expression for this kind of thing, see

RunningValue Function (Report Builder and SSRS)

This works for your data and example:

A simple table based on this:

Expression Total :

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

Which gives the expected results:

Depending on your fine-tuning, you may need to change the Scope parameter to Group or Dataset , but Nothing works in a typical case.