Changing "Currency Fields" of Number Fields

Question

Hi,

I am having a problem to which I cannot find any solution. My application is in VB 2005 and I am having a problem changing the currency symbol on the Crystal Reports number fields. I want to do that from code but I cannot find a way to do it at all. Please help.

Answer 1

Crystal Report uses default culture and locale information from system to generate culture related format. If you want to skip it, don't use you number fields. Instead, generate a Formula Field, like the following:
"¥" + ToText(<NumberFieldName>, 2)

Sean Zhu

Answer 2

Hi,

Yeah that's a very good idea. Just to understand your post. You said I should not use the number field but your suggested formula is referencing a number field! Do you mean hide the original number field and reference it from within a formula field?

Thanks

Answer 3

Delete the number field in your report (but not the database expert! or else you cannot reference it), then, drag and drop the formula field to your report.

Sean