web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How to get sum of last amount in rdlc report

(0) ShareShare
ReportReport
Posted on by 289
Hi Guys,
I want to get add value by value & to get sum.
First value will be the same .i .e. 1 & then  add the amount in that total that comes one by one.
like below example , Here I have 2 columns. one is Amount & second is Total.
so in total column ,I want to get sum of last amount value. i.e.  my first total value is 1 & amount value is 2 . so 1+2 =3, 3+3=6, 6+4=10 like this.
Is any way to do this.
 
I have the same question (0)
  • Suggested answer
    KasparsSemjonovs Profile Picture
    4,766 Super User 2025 Season 2 on at
    You would need to add a new Variable, and then filter the amounts based on Line number. 
    For 1st line, you Sum the amounts with filter Line No. = ..10000, for 2nd line it would be ..20000 and so on. as the line number could be different, You would want to filter .."CurrentLineNo"
  • Suggested answer
    Kamal Khakhkhar Profile Picture
    1,276 on at
    hii there,
     
    as per your requirement you need to add Running total for your report , for that i provide a link you can go through it. You can get idea about it.
     
     
    If You get your answer , Mark it answered.
     
    Thank You,
    Kamal Khakhkhar.
  • Test user Profile Picture
    289 on at
    Yes as my requirement is for Customer-to balance report.On that report i want to add Running balance column.
    I have write this expression on my text box:
    =RunningValue(Fields!OriginalAmt.Value,Sum,"CustLedgEntry1")
    =RunningValue(Fields!OriginalAmt.Value,Sum,"DataSet_Result")
    =RunningValue(Fields!OriginalAmt.Value,Sum,"No_Customer")
    but it is not working. can we do this code throgh?
     
  • Suggested answer
    YUN ZHU Profile Picture
    95,548 Super User 2025 Season 2 on at
    As far as I know this can be done in AL, if it is difficult in RDLC, it is recommended to try other ways.
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Test user Profile Picture
    289 on at
    Hi yunzhu, can you give me an idea about done through AL code. 
  • Test user Profile Picture
    289 on at
    How it done through AL code

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans