Print Page | Close Window

currency symbol

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10945
Printed Date: 03 May 2024 at 12:03am


Topic: currency symbol
Posted By: Pink
Subject: currency symbol
Date Posted: 24 Aug 2010 at 10:46am
Hi,
I need to display windows curency symbol in my reports...
I found a nice option in the currency tab : "Use default format"...
I'm sure it will do what I want but the option is disable...

Thanks in advance
-Pink


Replies:
Posted By: Emir_W
Date Posted: 25 Aug 2010 at 12:11am
try to help.
(assume you using Crystal XI).


currency setting is based on your system setting (regional setting).

you can right click the field - Format field.
from here you can set/check 'Display Currency symbol'.

click on 'Customize...' button.
from here you can set/check 'Use Account format'

click on 'Currency Symbol' tab.
from here you can setup the Currency symbol as you wish.


hope it help.



-------------
Emir W

Posted By: Pink
Date Posted: 25 Aug 2010 at 3:00am
I know that I can set my currency symbol in that page(already done it to change it to % in some reports), but what I need to do now is make it use the system format(window)

I changed my format to Euro and ran the report but it was still $ that was there....

I know that I can set the good value in the formula of the currency symbol but I was kind of hopping for an automatic thing since I have over 200 reports to update, each of them containing couples of money format....

thanks

Posted By: Emir_W
Date Posted: 26 Aug 2010 at 1:25am
mmm..
the point is the setting in Regional Setting.

and in CR you can set from:
- click File - Options
- Fields tab
- Select 'Currency'
  and set the Currency symbol as you wish

this setting will applied for all report.

note:
make sure that the field in each report is 'Currency' (not Number).


hope it help.



-------------
Emir W

Posted By: Pink
Date Posted: 08 Sep 2010 at 11:13am
Originally posted by Emir_W


note:
make sure that the field in each report is 'Currency' (not Number).


This was probably the problem... Thanks, I will not forget this one...

Since my boss was pushing for this option,  I finally did the long shot (not so hard as I first imagine) by adding a parameter "Symbol" to each report and assigning the symbol fomula of each field to use its value...

-Pink


Print Page | Close Window