data format not possible

[rajmns]

Hi All,

I am trying to change the format of a particular field. It contains numbers and I believe the format is varchar. When I try to include a thousands separator or decimal values, the changes do not reflect when the report is run. Can anyone help me with this?

Thank you.

 

[blom0344]

Did you try to cast the varchar to a numeric type and then apply a specific format?

Ties Blom

 

[sln007]

If all of the values contain only numerics, then casting the varchar field to a number, then using the data format property will work.
If a cell has a alphabetic or non-numeric value, then the conversion will not be successful.

Steve N.
State of Ohio, MIS