NAV 2016 Word report is generating extra 0

carsten_toft

Hi,

I have made a report in NAV 2016 using Word and XML. Everything is very well, but I have one problem.

When "quantity" is added to the report, NAV writes "0" in all cells with no information. In the attached picture saying "with error" you can see that the "quantity" cell with no information is filled with "0".
In the picture "No error" I have shown how I would like it to look.

Can somebody help me?

roberto.stefanetti

no, only in C/SIDE in this case (simple common solution), i use in this way (no logic in Word, all in C(SIDE)

but.. i think that you can create functions in Word (macro) in word template.
you can modify XML an add also Javascript support... an so on..

roberto.stefanetti

hi,
you can use this function Num2Str
called in fields of dataitem ex: Num2Str(Quantity)

Num2Str(IdecValue : Decimal) OtxtValue : Text[100]
IF IdecValue<>0 THEN BEGIN
OtxtValue:=FORMAT(IdecValue,0,'<Precision,2:2><Standard Format,0>');
END;

carsten_toft

Thank you for the fast answer.

Can this code be integrated directly in Word?

roberto.stefanetti

no, only in C/SIDE in this case (simple common solution), i use in this way (no logic in Word, all in C(SIDE)

but.. i think that you can create functions in Word (macro) in word template.
you can modify XML an add also Javascript support... an so on..