CODEWITHSUNDEEP
vb.netrdlcvb.net-2010
Samuel Adam
Samuel Adam

Reputation: 1337

Vb.Net RDLC sum field with same field's previous values

To the point, I created a report using Report Wizard on Visual Studio 2010 Vb.Net. The layout is pretty much like this : 

          DEBIT               CREDIT               BALANCE (FYI, this is an Expression)
      -----------------------------------------------------------------
         DValue1              CValue1           DValue1-CValue1 
         DValue2              CValue2           DValue2-CValue2+DValue1-CValue1
         etc...
      -----------------------------------------------------------------
Total    DTotal               CTotal

I managed to create up to the DTotal and CTotal, what problematic is when I want to create the Balance with Expression.

I tried this Expression, still no good. =Sum(Fields!Debet.Value)-Sum(Fields!Credit.Value)+Previous(Fields!Debet)-Previous(Fields!Debet). This Expression returns an error that I should not use an aggregate within another aggregate.

Please help me with this. There aren't many rdlc related tutorial even on google.

Thank you so much.

Upvotes: 1

Views: 5094

Answers (1)

lc.
lc.

Reputation: 116528

Untested, but I believe you're looking for the RunningValue function:

=RunningValue(Fields!Debet.Value,Sum,"MyGroupName") - RunningValue(Fields!Credit.Value,Sum,"MyGroupName")

Upvotes: 2

Related Questions