How to make the integer with no decimal and comma

[EngJoo]

greetings,

i write a formula like:-

totext({site.site_no})+'-'+totext({site.site_addr1})

and the result that i get is:-

30,314.00-Jalan Chan Sow Lin, KL

but result that i wish to get is

30314-Jalan Chan Sow Lin, KL

So is there a missing piece on my formula that i wrote?
Please advise.

i am using CR8.0

 

[kenhamady]

totext({site.site_no} , 0 , "&quot Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[Fenriswulf]

Hi.

The formula should be
totext({site.site_no}, 0, "&quot+'-'+totext({site.site_addr1})

the zero is the number of decimal places and the empty string will overide the default settings for the thousands separator.