I am using VS2010 and Crystal reports plug-in and getting a value from stored procedure. The values on this field are whole numbers and some of the numbers do have decimals.

Col 1
-----
42
25,725
5.22

When I right-click and format object. I am unable to achieve this. If I enable decimal it is displaying

42.00
25,725.00
5.22

How can I achieve the format that I have mentioned. I appreciate your support.

I tried the following formula:

//FieldOne is float
//Probably don't need the else. 

If InStr(ToText({proc1;1.FieldOne}),".") > 0 THEN
Truncate({Proc1;1.FieldOne},2)
Else
Truncate({Proc1;1.FieldOne})

I am getting a "string is required here." error