I am using the Crystal Report 2008, I have one issue regarding the currency symbol in the crystal report.
it seems the CrystalReport use the System Default currency symbol. e.g.
ProductA Cost: $1000
ProductA Cost: £1000
in euro locale and $ in english locale
It doesn't make sense in business. The question is how do we set the currency symbol "$" to the report? I google some websites, the SetLocaleInfo may be one option, I would like to know the detail and if there are more solutions.
Thanks for your help
Try with SetLocaleInfo.Might be some setting of system is changed.
Right click on your fileld -> select Format field ->Number tab
Check that style is System Default Currency format or Fixed viewing locale currency format.
Make it System Default Currency format.
Thank for quick response!
The issue with SetLocaleInfo is that if the application terminate because of some reason, the system local will be changed. We don't want to affect end user's regional setting.
Will SetThreadLocale work???
Is there any other way to do it?
Thanks all for your kindly help.
Because there are many report templates, so I can't use the formula.
I chose to use the SetLocaleInfo. However, there is one new issue
When change the currency of system locale first time, Crystal Report Viewer shows the correct currency symbol.
However, when I close the Print Preview and change the system locale currency symbol, and open the Print Preview dialog again, the Crystal Report Viewer still displays the old one which set in the first time.
Any help is highly appreciated.
Before in our legacy application, we used Crystal Report 9 & VB
'Crystal Report Designer Components (RDC).
Set CrxApp As New CRAXDRT.Application
I can set the crxapp to nothing and recreate this design component.
Set CrxApp = nothing
After SetLocaleInfo, if we set the CrxApp to nothing, it will create the RDC and the currency symbol will be updated.
Now we are using Crystal Report 2008 and C#, the RDC is not supported in 2008
What can I do?
Any input is greatly appreciated.
Edited by: Dennis Zheng on Feb 17, 2009 3:57 PM