[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

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

Kyle Witter
Kyle Witter
1 Solution
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)

Kyle WitterAuthor Commented:
This worked perfectly, thank you!

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now