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
1,589 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
  • 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 100

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
 

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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 19

Expert Comment

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

Gary
0
 
LVL 100

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 100

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 100

Accepted Solution

by:
mlmcc earned 500 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

705 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now