Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Currency Symbol displaying $ instead of locale default in ASP.NET environment (Both server and client on English(UK)

Posted on 2004-08-22
11
Medium Priority
?
1,762 Views
Last Modified: 2009-12-16

The web front (ASP.NET) Reporting application has been developed using Visual Studio .NET (Microsoft Visual C# .NET) with crystal reports being displayed via the crystal report viewer (CrystalDecisions.Web – Version 9.2.3300.0).  The database is SQL Server 2000.

We design the reports using Crystal Reports Developer 9.2.3.970.

We have sites in the United Kingdom and wish to display currency values with the Pound symbol as opposed to the Dollar sign.  All relevant fields have been formatted using the System Default Currency Format.

The Regional settings and Browser “Language” settings have been changed to “United Kingdom” on both the web server machine and clients, but the $ symbol is still being displayed for all currency values on all crystal reports.





0
Comment
Question by:pgordon2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +1
11 Comments
 
LVL 19

Expert Comment

by:GJParker
ID: 11868267
Do you have CR installed on the UK web server ? if so have you tried changing the currency settings in CR Options ? go to the Fields tab and change the currency settings.

Gary
0
 
LVL 42

Expert Comment

by:frodoman
ID: 11869023
If you always want the Pound symbol, you can format the field, select custom format, currency options, and enter the symbol that you wished to be displayed.

frodoman
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 11869878
According to this link if you set the Windows defaults correctly it should xhange automatically.
http://support.businessobjects.com/library/kbase/articles/c2011510.asp

Here is a solution from a previous version.  It may still be applicable
http://support.businessobjects.com/library/kbase/articles/c2001783.asp

mlmcc
0
Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

 

Author Comment

by:pgordon2
ID: 11899461
Thanks for the comments.
GJParker, we have tried the issue on a local machine, and the currency symbol works correctly through the designer but not through the viewer on the same machine (We are using the ASP.NET Viewer).
frodoman, we want the currency symbol to change depending on the locale the report is used in, otherwise we would fix it.
mlmcc, thanks for the comments. This SHOULD work .. sounds like a bug somewhere. On the second link I would assume that problem is fixed since version 6 and the workaround they suggest is too much work and would make the reports harder to maintain.

thanks,
paul.
0
 
LVL 19

Expert Comment

by:GJParker
ID: 11900343
sorry I can't be of more help.

Gary
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 11909242
WHere is the server the machines are running against?  Is it the same server or do the UK sites have a server located in the UK?

mlmcc
0
 

Author Comment

by:pgordon2
ID: 11909455
The server is situated in the UK and is set to use the UK Locale in Windows. The clients are accessing the reports via the Web using the ASP.NET viewer and are also in the UK.

Paul.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 11909558
Have you tried setting the language to something, reboot, then set it back to UK and reboot?

mlmcc
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 11909569
I just tried to reset my regional settings.  I set the regional setting to English(UK) but the other settings remained the same.  Have you gone in and set the currency settings to use the appropriate symbols?

mlmcc
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question