Make SUM of Column value of all row up to current row in SSRS

Question

I have webapplication having SSRS Reports...

I have a situation where i have to Update sum of particular field into last column for all above row up to current row..

for example..

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

In Above table, last column Total makes sum of value of Balance column of all above rows.. how can i achieve this ?

Thanks..

Answer 1

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

RunningValue Function (Report Builder and SSRS)

This works for your data and example:

A simple table based on this:

The Total expression is:

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

Which gives the expected results:

Depending on your exact setup, you may need to change the Scope parameter to a Group or Dataset value, but Nothing works in the typical case.