How can i get rid of thousands place holder? 1

[crystaldev1]

Hello. I have this formula:

If Year({Plans.dtComplete}) = Year(currentdate)
then MonthName(Month({Plans.dtComplete}))
else Cstr(Year({Plans.dtComplete}),0)

This formula works fine but I cannot get rid of the thousands place holder. (ex. 2,008). I would like to it to appear as digits. Thank you.

 

[BeeBear]

You didnt say what version of Crystal you are using....

I'm guessing the formula is a number format - Have you tried changing the formula format to remove the thousands separator? Just go into FORMAT FIELD, or highlight the field and click on the , button in the toolbar.

I'm not sure how to change the format within the formula.

Hope that helps

regards

BB

*** Count your blessings not your problems******

 

[dgillz]

I am not familiar with cstr(), but try this:

Cstr(Year({Plans.dtComplete}),0[red],""[/red])

If that doesn't work, replace Cstr with ToText.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[crystaldev1]

Thanks dgillz. Adding "" to the formula worked. I knew the third parameter for Cstr is for that but just didn't know how to add nothing as a holder. Thanks once again.