cancel
Showing results for 
Search instead for 
Did you mean: 

How to set currency symbol correctly in crystal report

Former Member
0 Kudos

Hi all,

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

It displays,

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Dennis,

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.

Regards,

Shweta

Former Member
0 Kudos

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?

Regards

Dennis

Former Member
0 Kudos

Hi Dennis,

Not sure about SetThreadLocale work try to test at your end.

One thing you can try is with create formula and place that formula in details section.

To create formula use Type conversion Function.

Regards,

Shweta

Former Member
0 Kudos

Try this formula:

'$' + CStr(CDbl({Customer.Last Year's Sales}))

Caroline

Edited by: Caroline Keller on Feb 17, 2009 8:47 AM

Former Member
0 Kudos

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.

Former Member
0 Kudos

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