number to string

[rb2005]

I have a field which is number data type. Let say the field name is Amount, value is 1,200.00. I want to convert it into string so that the value will display like 1200.
I am using totext to convert it. But I am not sure how to remove the "," which is nothing but thousnad eparator.
In oracle 9i the value is 1200.00, but some how CR10 getting it like 1,200.00.
I need help.

 

[synapsevampire]

You don't need to convert it to s string to do this, but formula of:

totext({table.field},0,"") will accomplish this.

What Crystal is displaying is your default settings for a numeric type, it isn't converting anything. Use the Report->Options->Fields to change the default characteristics of the field types.

It would be best if you just right clicked the field and selected format field->Number and select from the defaults, or hit Custom and set it how you'd like.

-k