Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / How to get sum of last...
Business Central forum
Suggested answer

How to get sum of last amount in rdlc report

(0) ShareShare
ReportReport
Posted on by Member 129
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:
Reports and Business Intelligence
  • Member Profile Picture
    Member 129 on at
    How to get sum of last amount in rdlc report
    How it done through AL code
  • Member Profile Picture
    Member 129 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 68,586 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
  • Member Profile Picture
    Member 129 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 255 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,666 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"

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,326 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,166 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans