Unanswered: Need to remove commas from Numeric Parameter
I am using Crystal 2008 and have a dynamic pick list of numeric order numbers. The problem is the list is being displayed with commas. I have tried to use a formula for the parameter totext but have been unsuccessful in suppressing the commas.
I found this post on the same topic elsewhere and agree with them. You should be able to convert your number to a string before the data comes into crystal by using CAST(YourNumberField as VarChar(15)) Change the length to the number of digits in the longest number in your field.
Thank you very much but I was trying to avoid casting it to string. It is actually sent to a stored procedure which expects a number. If I cast it then I need to change the stored procedure but if that is the only way then I will do that.