Hi all,

I have a report (CR10) that I have just added a barcode formula field to using IDAutomation UFLs (and that was no mean feat in itself).

The problem is, that no matter what I do to the formula the field still comes out in the format: "13,255.00" wheras what I want to see is "13255" as this is an ID number not a currency.

I don't seem to have any options anywhere to change what CR sees it as.

Does anyone know what I'm doing wrong - it seems that this should be something simple, but I've been searching/struggling now for around 4 hours.

Here is the function I am using:

IDAutomation_Code128(cstr(ToNumber({RptRawMaterialGoodsInPalletLabel.ORDER_DETAIL_ID})))

I just changed it to 'totext' (as above), but the result is still:

31,818.00

In the table it's coming from it's an INT field and it's value is: 31818.

Glad you got it