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!