12,241,975 members (44,383 online)
Rate this:
See more:
Is there a way to calculate sum per row of table in rdlc report. To be of the following form:

Initial amount: x.

Number-----Amount-----Payment-----Sum
1---------------a-------------p1----------(x+a-p1)
2---------------b-------------p2----------(x+a+b-(p1+p2))
3---------------c-------------p3----------(x+a+b+c-(p1+p2+p3))
4---------------d-------------p4----------(x+a+b+c+d-(p1+p2+p3+p4))
5---------------e-------------p5----------(x+a+b+c+d+e-(p1+p2+p3+p4+p5))
Posted 8-Feb-13 2:57am
AR1988716

Rate this:

## Solution 1

Perhaps you could do the cumulative total on SQL and then populate the report?

http://stackoverflow.com/questions/2120544/how-to-get-cumulative-sum[^]
AR1988 13-Feb-13 6:06am

I need to do it in rdlc expression not in sql
Rate this:

## Solution 2

You could use an expression which uses =Sum(Field1!Value) + Sum(Field2!Value).....
AR1988 13-Feb-13 6:07am

I'm using the sum expression but need it to be nested with IIF to check for row index

Top Experts
Last 24hrsThis month
 OriginalGriff 595 Dave Kreskowiak 400 Sergey Alexandrovich Kryukov 300 F-ES Sitecore 280 KARTHIK Bangalore 274
 OriginalGriff 9,983 F-ES Sitecore 5,058 Jochen Arndt 4,468 Dave Kreskowiak 4,338 Richard MacCutchan 4,061