great a total in a dataport

marcolde

Hi,

i create a dataport with they i would export lines from a general journal line.
at the end i need a control total, but i do not know how i create a the total for the debit amount or credit amount from the general journal lines.

so i have three data items.
the last one is for the general journals i use the follow code

<Gen. Journal Line> - OnPreDataItem()
SETFILTER("Document No.","Payment Line".GETFILTER("Payment No."));
SETFILTER("Account Type",'<>Bank Account');


<Gen. Journal Line> - OnBeforeExportRecord()
//CLEAR(genjour);
   
Number1 := '7999-999';

CredittotAmount += "Credit Amount";-> here it does not create a total for the columns only shows every seperated line
DebittotAmount += "Debit Amount";-> here it does not create a total for the columns only shows every seperated line
TotAmount += Amount;-> here it does not create a total for the columns only shows every seperated line

file1 := "Payment Line".COUNT; -> this one works and shows the correct numbers of lines in the dataport

thanks for helping and sorry for the terrible english.

Marco