Convert String in Crystal Reports 2008

I've got a barcode that is supposed to be for a quantity, but when the barcode exceeds a digit over one thousand, a comma appears in the output.  Is there a way to convert the string so that it won't display/output the comma in either the barcode or on-screen?  An example would be the code (attached) should output "Q1000", not Q1,000


"*Q" & {?PalletQty} & "*";

Open in new window

barcode-problem.jpg
LVL 1
Kyle WitterAsked:
Who is Participating?
 
mlmccCommented:
Try explicitly converting the string.  The implicit conversion of a number to a string uses the default format


"*Q" & CStr({?PalletQty},0,"") & "*";

0 - number of decimals
"" - thousand separator (none)

mlmcc
0
 
Kyle WitterAuthor Commented:
This worked perfectly, thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.