12,753,809 members (34,640 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
 Graeme_Grant 350 ppolymorphe 281 Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 150 Maciej Los 140 Jochen Arndt 126
 OriginalGriff 3,961 Peter Leow 2,966 Karthik Bangalore 2,375 ppolymorphe 2,303 Richard MacCutchan 1,554