Avoiding thousand separator in Crystal Report Field

This discussion [^]may help.

well... a progress in this issue is that thousand separator has been removed but still decimal places comes up

I removed the thousand separator by :

replace (cstr({FieldName}),',','')

But now my problem is that the decimal places still comes up... I have set the Decimalplaces property to 0 and the removed the decimal symbol but still it comes up..

please help

try replace(cstr(totext({FieldName},0)),',','')

Hi,

May be this could solve your problem.

1. Select the feild in the crystal report.
2. Right click on the feild and select format object.
3. Select the Number tab.
4. In the style box select the required style.

Thanks

Just Right Click on the field, Format Object -> Number -> Customize -> Check On Thousand Separator -> Click on Formula button Of Symbol (Right side of symbol text box) and add '""' two quotation mark click on save.

hai try to this coding for crystal report

first declare the variable
Dim mGrossWeight as String

if {sp_Rpt_Doc_PackingList.GrossWeight} >0 then
    if {sp_Rpt_Doc_PackingList.GrossWeight} = truncate({sp_Rpt_Doc_PackingList.GrossWeight},0) then
            mGrossWeight     =   ToText({sp_Rpt_Doc_PackingList.GrossWeight},0,"")
    else
            mGrossWeight    = ToText ({sp_Rpt_Doc_PackingList.GrossWeight},2)
    end if

    mGrossWeight = mGrossWeight
else
    mGrossWeight = ToText({sp_Rpt_Doc_PackingList.GrossWeight},0,"")
end if

formula = mGrossWeight