GS1 Code 128 Barcode Identifier 320

[Stephan]

Hi,

I am creating a label in report designer which will include a Code128 barcode. The barcode will include the identifiers 01,13,320 and 21. 

GS1 identifiers: https://www.gs1-128.info/application-identifiers/

I am stuck with building the identifier 320 net-weight in pound (two decimal places --> 3202). Within the database I find values like 7.4563 or 34.2300 or 101.1000, etc. My question is how to round the value, get rid of the separator and to add leading zeros? Values should look like 000746, 003423 and 010110.

The round() functions seems to work with decimal places and I don't find any function to add leading zeros. 

Any help is greatly appreciated! Thanks!

[Stephan]

The round() functions seems *NOT to work with decimal places and I don't find any function to add leading zeros. 

[Katia]

Hello Stephan,

To complete the task, my suggestion is to treat the data fields as strings, conversion can be done using CStr() function. After that, you can use text functions (the combination of Join(), Len(), Split()) to format the text and append the leading zeros.
For more details about built-in function check this article.


Regards,
Katia
Progress Telerik