Click here to Skip to main content
12,241,975 members (44,383 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# 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 2:57am
AR1988716
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 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 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160426.1 | Last Updated 8 Feb 2013
Copyright © CodeProject, 1999-2016
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