Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# WinForm RDLC
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 1:57am
AR1988702
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Perhaps you could do the cumulative total on SQL and then populate the report?
 
If so, please refer
 
http://stackoverflow.com/questions/2120544/how-to-get-cumulative-sum[^]
  Permalink  
Comments
AR1988 at 13-Feb-13 6:06am
   
I need to do it in rdlc expression not in sql
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

You could use an expression which uses =Sum(Field1!Value) + Sum(Field2!Value).....
  Permalink  
Comments
AR1988 at 13-Feb-13 6:07am
   
I'm using the sum expression but need it to be nested with IIF to check for row index

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 595
1 OriginalGriff 295
2 CPallini 210
3 PIEBALDconsult 150
4 Fredrik Bornander 140
0 OriginalGriff 5,835
1 Sergey Alexandrovich Kryukov 5,263
2 CPallini 4,750
3 George Jonsson 3,227
4 Gihan Liyanage 2,487


Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 8 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100