2
CurrReport.CREATETOTALS(StartingExpectedQty,IncreaseExpectedQty,DecreaseExpectedQty,
StartingInvoicedQty,IncreaseInvoicedQty,DecreaseInvoicedQty);
The code is in the Inventory Valuation report on Item-OnPreDataItem trigger which is a standard report.
*This post is locked for comments
As you are using 2016 version, it might not be of your interest, as this function is not supported on client report definition (RDLC) report layouts. In most cases, when you create a layout suggestion for a Classic report layout that uses the CREATETOTALS function, a SUM expression is created instead and no action is required.
Hey,
CREATETOTALS simply do the totalling of the variable. All are decimal fields.
CurrReport.CREATETOTALS(StartingExpectedQty,IncreaseExpectedQty,DecreaseExpectedQty,
StartingInvoicedQty,IncreaseInvoicedQty,DecreaseInvoicedQty);
Here in the report it will do the net sum of all the variables which has been passed with comma separator.
It just maintains totals for those variables so that when you use those in the Group or Footer section it will display the totals, just like SUM function in RDLC.
Hi
If you are using NAV version 2013 or above , The Currreport.createtotals is an obsolete function, in 2009 or below versions this code used to calculate totals in classic report.
CREATETOTALS function keeps Totals for the vaiables or fields mentioned which further can used to put on the Report Footer.
-Yogesh Kulkarni
Please verify, if you find answer helpful.
Check this link for understanding the function details
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
