Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Fake it until you make it
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

28
February

How Do I Display the Different Currency Symbols in Crystal Reports 2008?

I am currently working with client, using Crystal Reports 2008, creating international sales reports for their myriad of customers buying from different regions and countries around the world.  I was asked "How do I display the different currencies of the sales table?"

The different currencies required was:
  • Chinese Yuan
  • Euros
  • Indian Rupees
  • Japanese Yen
  • Sterling
  • Nigerian Niara
  • Polish Zloty
  • Russian Rubles
  • Thai Bhat, and
  • US Dollars

Solution

The easiest way to achieve this was to use a formula, using a nested If Then Else operator and the ChrW function to display the different currency symbols after the sales amount.

The formula:

If {Tablename.Fieldname} = "Euro" then ChrW(8364) & (Totext({Tablename.Fieldname},"#,###.00") 
else
If {Tablename.Fieldname}  in ["Yuan","Yen"] then (Totext({Tablename.Fieldname},"#,###.00") & ChrW(0165)
else
If {Tablename.Fieldname} = "Dollar" then ChrW(0163) & (Totext({Tablename.Fieldname},"#,###.00") 
else
If {Tablename.Fieldname}  = "Thai Bhat" then (Totext({Tablename.Fieldname},"#,###.00") & ChrW(3647)
else
If {Tablename.Fieldname}  = "Rupee" then (Totext({Tablename.Fieldname},"#,###.00") & ChrW(8360)
else
If {Tablename.Fieldname}  = "Russian Ruble" then (Totext({Tablename.Fieldname},"#,###.00") & ChrW(1088) & ChrW(1091) & ChrW(1073)
else
If {Tablename.Fieldname}  = "Polish Zloty" then (Totext({Tablename.Fieldname},"#,###.00") & ChrW(0122) & ChrW(0322)
else
If {Tablename.Fieldname}  = "Niara" then (Totext({Tablename.Fieldname},"#,###.00") & ChrW(8385)
else
ChrW(0163)



If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us
1

Chandrakant

14
February
i want Indian Rupees Symbol in Vb 6 crystal Report
2

Julia

22
February
The Ascii Code is ChrW(8360)

Unicode Character(U+20B9)
3

Mac

30
November
select {OrderHed.CurrencyCode} case "CYN" : {OrderHed.CurrencyCode} + chrw(165) case "EUR" : {OrderHed.CurrencyCode} + chrw(8364) case "EURO" : {OrderHed.CurrencyCode} + chrw(8364) case "GBP" : {OrderHed.CurrencyCode} + chrw(163) case "RMB" : {OrderHed.CurrencyCode} + chrw(165) case "SGD" : {OrderHed.CurrencyCode} + chrw(36) case "USD" : {OrderHed.CurrencyCode} + chrw(36) default: {OrderHed.CurrencyCode}
4

leangeSaK

09
March
It is really mostly very difficult to view well-aware unique on this area, but you find as just like you fully understand those things you're preaching about! Many thanks

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

13 + 29 =