formating with commas 2

[CTLReporting]

Hi all,

I have a problem. I have converted a number into a string in a formula. But when converted to a string it adds commas aftert thousands. If the number was 1005 my formula is supposed to say 1005/2 but instead it ends up saying 1,005/2 and when scanned by a barcode scanner it messes everything up. Does anyone know how to fix this?

Thanks,


CTL Reports Group,
Running Crystal Reports 8.0 and 8.5
Bentonville, AR
FoodLabReports@ctlusa.net

 

[mbarron]

I'm assuming you used the ToText function. To get rid of the comma use

ToText({your.number.field},0,"&quot

The 0 is number of decimal places, , the "" is the thousands seperator.

Mike

 

[CTLReporting]

Yes, I used the totext() function.

Thanks, worked great!

CTL Reports Group,
Running Crystal Reports 8.0 and 8.5
Bentonville, AR
FoodLabReports@ctlusa.net

 

[LMRollins]

I keep telling my husband that this site is one of the best sources of information and he didn't believe me until now. We had been struggling with this same bar code issue and I found this post and it solved his problem. Thanks Mike. You're a life saver.

Lori