TOTALSCAUSEDBY in nav 7

Business Central/NAV User Forum
1

Hi,

I want to ask with which function in NAV7 is repaced TOTALSCAUSEDBY function from Nav 6.

ex: How can be implemented this in NAV7:

CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY = “Table1”.FIELDNO(“Field 1”));

Thanks in Advance

2

totalscausedby is no longer working in nav 7.

where do you want to use this in nav 7… in groupfooter may be to show the footer section…?

NAV 7 MAKE THE GROUPINGS INDIVIDUAL THEN SHOW ONLY THOSE FOOTER WHICH HAVE THE SUM VALUES…?

this is just a workaround… if you can share the problem in detail… i can try to help you,.

Anil.

3

Yes,this is for group header and for group footer. I found how to implement this in VS, but I have export excel too(and that should be made by code).

I have two groups one by Field1, and other one ,intended, by Field 2:

HeaderGroupbyField1

RecGroupbyField2

RecGroupbyField2

RecGroupbyField2

FooterGroupbyField1

In CC showing of Header/FooterGroupByField1 is controlled by :

end filling in excel file works ok (IF(SHOWOUTPUT) Then enter Header/FootherGroupbyField1) in excell file(Buffer)-This code is on section)

But how can I tell in Nav 7,by code, that if grouping is by Field1…then print header from first group?

This code should be OnAfterGetRecord. By now I am getting this result in ExcellFile:

HeaderGroupbyField1

RecGroupbyField2

FooterGroupbyField1

HeaderGroupbyField1

RecGroupbyField2

FooterGroupbyField1

HeaderGroupbyField1

RecGroupbyField2

FooterGroupbyField1