on 01-06-2015 3:24 PM
Dear All,
We have currency field for which we have set system default currency format in Number tab of Format Object of crystal report but still it is showing the $ symbol ?
What would be the solution ? Any idea , we are using VS 2010 Crystal Report In Build.
Thanking you,
Miral Shah
What version of Visual Studio are you using?
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Let me change my question: Are you using the SAP Crystal Reports version for Visual Studio that you can find here http://scn.sap.com/docs/DOC-7824 with VS 2010 or are you using the SDK that came with earlier versions of Crystal?
If you're using CR for VS, what service pack are you using?
-Dell
Hi Miral,
First you cannot set the currency symbol to System Default because if you check on the Use Currency symbol it goes to custom:
System Number format does not handle the Currency symbol.
Next issue is if you click the Customize button you get this UI:
You cannot paste in any symbol, it has to belong to the font you are using. To specify start up Character Map and select your font:
click on the symbol you want to use and then Select and then Copy.
Now you can paste it into the CR UI:
This will not work if that font is not installed on the users PC so try to use a common font or like I used as the Arial Unicode MS.
An example is if you copy this character ¥ and then paste it into the Currency symbol box you will see it in CR Designer but may or may not see it in the Viewer.
So depending on the font you select, which symbol you use and how you set it depends on if the Windows app or WEB app is able to view the symbol. Also requires the font to be installed on each PC and/or WEB Server.
So now the real issue...
Your value I assume comes from a database field and that value is for example Canadian Dollars which is the $. Now you want to display the currency symbol based on the persons local so not you would see a £ in front of your Canadian dollar number???? As you can see this would be completely wrong and misleading.
So you have a few ways to handle this:
#1. In your data source specify what value the currency was saved in and have a file with the currency symbol and then simply use it in the Currency formula, click on the X+2 button and simply select your CurrencySymbol field.
Or if you really want you could use this formula function - ContentLocale and it is based on the Locale of the PC but this gets tricky to handle due to the above explanation...
So, what exactly are you trying to do and what is the database you are using and anything else to explain why you want to change Symbols?
Don
Dear Mr.Don Williams,
Thanks a lot for wonderful explanation. Explanation is so clear that it ill make life easy for new developer like me.
Let me explain my problem very precisly as under
We have money type sql server 2008 or 2005 field in database and it is curency in CR VS 2010 report. I dont store currency symbol in database. We want to it come from pc or server culture , because we have multiple client in various contries having different currency.
When we change culture in development pc and run the report from VS 2010 it is working completely fine but when we publish our report in IIS then it is not taking culture as per IIS Net Globalization setting or server culture.
I hope you got my concerns , if we resolve this issue it would be great help to all sap crystal report developer and highly oblidge to you for replying me.
Thanking you,
Miral Shah
Dear All
Below link show half solution how to proceed further and get culture on report document. Even sap knowledge base article is not accesible
Help me please.
Thanking you,
Miral Shah
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
your url has 2 http:// in it, change it to only one and then the link should work
Don
Difficult to say as we have no idea what you actually did. Have a look at the following, see if that helps:
1555742 - How to configure the multilingual options for the Crystal Reports .NET web form viewer
1711136 - How to set Culture per report using the Crystal Reports SDK for VS .NE
SAP Crystal Reports .NET SDK Developer Guide
(search for 'culture')
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow us on Twitter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.