Negative Currency Appearance Different from Windows Setting

[CristinaD]

I am using Crystal Reports 8.5 and I have made changes to currency fields using the '$' sign which is working great at changing the currency symbol in international settings. However, if the currency is negative it now prints as '($42)' instead of printing as '-$42'. I don't want to force it to use the '-' sign because I would like for it to use the windows settings to figure out how negatives should be previewed(for international compliancy). Please let me know if anyone has any idea as to how I can go about fixing this. Thank You in advance.

Cristina

 

[synapsevampire]

A formula can force it to use the default currency format, such as:

currencyvar mycur := {table.field}

-k

 

[lyanch]

The use of - instead of ( ) is part of the regional settings for currency. On my system, () is the default for english (united states) currency. If the users want () instead of - they will need to changes their regional settings to that. You might check your own setting to see if they are "default" or have been changed and exactly what your settings are.

Lisa

 

[CristinaD]

Lisa,
That is what I thought as well but when I checked my regional settings it is set up to show negatives with the '-' symbol not with the (). I want it to change with the regional settings since I want the user to decide how negatives are viewed but it is not changing with the regional settings. Any other thoughts? Thanks

Cris

 

[lyanch]

Are you sure you are checking currency? regular numbers default to -. When I change my regional settings back and forth between () and - my reports change (I always let currency default to regional).

Lisa

 

[synapsevampire]

Are you sure that the field is a currency field?

That's why I supplied the conversion, it should inherit the settings if you've selected use the default windows settings.

-k

 

[CristinaD]

Thank you guys for all of your help. K, the conversion that you supplied did the trick. I don't know why ${table.field} did not work though. But it is working fine now. Thank you again for helping me out.

Cristina

 

[synapsevampire]

The field probably isn't a currency type, so it inherited the number format, not the currency format.

-k