Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2009
    Posts
    2

    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.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Can you give us some example values (complete with commas)?
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2007
    Posts
    33

    Convert To String Using Command

    https://forums.sdn.sap.com/message.j...sageID=5899330

    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.

    Good luck

  4. #4
    Join Date
    Sep 2009
    Posts
    2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •