Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to get sum of last...
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 Nil@@m 205
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.
 
Categories:
Dynamics 365 Business Central
  • Nil@@m Profile Picture
    Nil@@m 205 on at
    How to get sum of last amount in rdlc report
    How it done through AL code
  • Nil@@m Profile Picture
    Nil@@m 205 on at
    How to get sum of last amount in rdlc report
    Hi yunzhu, can you give me an idea about done through AL code. 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,595 Super User 2024 Season 2 on at
    How to get sum of last amount in rdlc report
    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
  • Nil@@m Profile Picture
    Nil@@m 205 on at
    How to get sum of last amount in rdlc report
    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
    Kamal Khakhkhar Profile Picture
    Kamal Khakhkhar 303 on at
    How to get sum of last amount in rdlc report
    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.
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,973 Super User 2024 Season 2 on at
    How to get sum of last amount in rdlc report
    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"

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans