Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Excellence can be obtained if you care more than others think is wise, risk more than others think is safe, dream more than others think is practical, expect more than others think is possible
 
Unknown
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:

23 + 17 =