Skip to main content

How Do I - Add Running Total in #msdyn365bc reports?

Hi Readers,

Microsoft added that feature in few pages but it's a feature that will be great in a report.

In this article we will discuss about How to Add Running Totals in #msdyn365bc reports.

#reports #runningtotals #businesscentral #msdyn365bc.

To Achieve running total, we don't need to modify anything in the report dataset. 

Pick any report which have a numeric field, and you can apply changes in the layout only.

With RDLC there are built in method, which we don't normally use.

To achieve running totals in a report we will use RunningValue method.

Sample Dataset 

How to use RunningValue

Sample Output 

To get access to Source Code, you can refer GitHub repo.

You can watch recording on YouTube also.

Hope this helps.

Saurav Dhyani


Popular posts from this blog

Welcome - Microsoft Dynamics 365!

Hi All, In this article we will discuss the new introduced member of Dynamics Family. Yes you heard it correctly, one more new member with Name "Microsoft Dynamics 365" . #ProjectMadeira   #Dynamics365

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.