calcformula data in export

axBobSE

Hi again I runed into a small problem Im exporting a bunch of Invoices to a text file

I created a dataport set it up acording to the devguild :P
but in the first line of each invoice I have a problem, the invoiceamount comes out as 0 in my file.

I guess the problem is that my field isnt a real field but a calced field the calcformula is:

FIELDNAME InvoiceAmount CalcFormula option

SUM(salesInvoiceTrans.amount WHERE (voucher = FIELD(voucher)))

Now is there a way that I can get the resault of the field written into a string?

The names might be a bit odd I translated them into english as its a danish client im using


Doh. found it when I get a record the calced fields are 0 by default and I have to call CALCFIELD on them before I can read them.