Removing Thousand and Decimal From a Numeric Field In Crystal Report

Hi guys,

Recently I faced a problem in crystal report where i had to convert a mobile no filed into the numeric field which should not have thousand and decimals in crystal report.

My field was coming from database. I just simply did this

Step -1) Right click on the field to which you want to perform the operation and click on Format object

Step-2) Now a format editor opens as shown in the figure and click on the button that is right alongside the "Display String"

Step - 3) Now opens the formula workshop...select the field in the first column from one of the three columns on the right side.

now at the bottom space write down the formula

Replace (cstr({Field Name},0,''),',' ,'')

all the thousand and decimals would be gone now..enjoy..

hope it will help you...!! :)