Resolved Questions

Leeroy1

How to change number format for Crystal Reports Barcode

I've been creating a barcoded pallet label and need to change the way the weight field is displayed. from 630.12kg to display as 063012 so it can be added to a barcode in Crystal Reports, is there a formula to do this?

Operating System: Windows 11

Application: Crystal Reports

06-25-24 74 day(s) ago

Report Abuse


debrac	Best Answer We can offer you this VB code that may accomplish what you need. This conversion could be useful for GS1 AIs 3102 (Net Weight in Kilograms) and 3202 (Net Weight in Pounds). This code is a portion of the ITF function in the Crystal Reports Barcode Generator. The input is DataToEncode and the result is NumberString. Note this code is in Visual Basic syntax and should also work in Microsoft Excel and Access. Dim DataToEncode as String DataToEncode = "Yourdata" Dim StringLength as Number Dim NumberString as String StringLength = Len(DataToEncode) 'Extract only numbers from the text For I = 1 To StringLength If IsNumeric(Mid(DataToEncode, I, 1)) Then NumberString = NumberString & Mid(DataToEncode, I, 1) Next I If Len(NumberString) = 5 Then NumberString = "0" & NumberString If Len(NumberString) = 4 Then NumberString = "00" & NumberString Please note that IDAutomation barcode software can only take the data you enter into it and encode it to either have a custom font applied to complete the barcode or generate an image of a barcode. If this formula does not work for you, IDAutomation would recommend that you review Crystal Reports formulas to complete this. You may have to reach out to SAP if you need assistance writing a Crystal Reports formula to complete this action. IDAutomation does not support Crystal Reports itself, only the barcode software to encode your data. Posted 74 day(s) ago (0) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

No comments yet. Be the first to comment.

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption	:
Link URL	:	(Must starts with "http://")
Add \| Cancel

Allow to insert an image. Must be among the following file types - .jpg, .gif, .png & .bmp.
Image Url	:	Upload New (Image url must always starts with " http:// ")
Width	:	pixels (Must not be greater than 450px. Enter 0px for no resize)
Add \| Cancel

Allow to insert YouTube video. Insert the video embed code.
Embed Code	:
Add \| Cancel

Up to 5000 Characters are allowed. Current Count: 0

Your comment on this answer

Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption	:
Link URL	:	(Must start with "http://" or "https://")
Add \| Cancel

Allow to insert an image. Must be among the following file types - .jpg, .gif, .png & .bmp.
Image Url	:	Upload New (Image url must always start with "http://" or "https://")
Width	:	pixels (Must not be greater than 450px. Enter 0px for no resize)
Add \| Cancel

Allow to insert YouTube video. Insert the video embed code.
Embed Code	:
Add \| Cancel

Up to 5000 characters are allowed. Current Count: 0

My Profile

You may answer and comment on any thread according to the Terms and Conditions.