TotalFields vs CurrReport.CreateTotal

Dynamics 365 Business Central/NAV User Forum
1

Hi everyone,

Whats the difference between TotalFields and CurrReport.CreateTotal

JDI

2

There is not much of a difference. You can create Total fields from code .

But this is told by the help too.

gabor

3

Hi,

Yes, there is not much difference but total fields some times shows wrong output, so use this syntax in onPreDataitem

currreport.CREATETOTALS(fieldname);

This will give exact output .take this in two reports using Total fields and using create total fields check this thing by using calculator you will find problem of total field property.

4

Hi Pandu,

But if I have GroupBy 2 fields in a DataItem (Eg: DataItem-Cust. Ledger Entry , GroupBy- Salesperson Code AND Customer Code), in my section designer how can I inform system to show grouping of Salesperson on First Cust. Ledger Entry GroupFooter and grouping of Customer on Second Cust. Ledger Entry GroupFooter

5

Use

CurrReport.SHOWOUTPUT :=

CurrReport.TOTALSCAUSEDBY = CustomerLedgerEntry.FIELDNO(“Sales Person Code”);

CurrReport.SHOWOUTPUT :=

CurrReport.TOTALSCAUSEDBY = CustomerLedgerEntry.FIELDNO(“Customer No.”);

6

Hi ,

You can find similar topics regarding this , please have a look at the search .

here is one example :

http://dynamicsuser.net/forums/p/9292/32202.aspx

g.