[Julie Macreadie]

I was wondering how difficult it would be to write a script (I am fairly sure I need a script) that will print Stock Quantities in a Visual Builder report in whole figures even though they are stored as 2 decimals in Capital? I need to make an adjustment to a report we wrote for Lion Nathan.

[COBS Tech Support]

Double-click on the field object you want to alter and change "Decimal Places" from "2" to "0". This should round the quantity displayed to the nearest whole number.

[Guest]

This doesn't work for me. But maybe it's because I have a script here. This is the script inside this field:

Declare XAvalab Type Numeric
XAvalab := AsVal(Stock->Stock_In) - AsVal(Stock->Allocated)
Return AsChar(XAvalab)

[COBS Tech Support]

Please change the last line of your script to read:

Return XAvalab

This is because you are returing a character string, not a number. Rounding settings are ignored unless your script returns a numeric value.