## 6 replies

Last post Mar 02, 2012 02:57 AM by Mahesh Darkunde

• aliyuusman4u

Member

29 Points

114 Posts

### convert currency to word in crystal report

Dear brothers, Please can anyone help me with function in crystal report that will help me convert currency to word. I will ge verry glad to see your reply on this question Thank you so much
• Mahesh Darku...

Member

462 Points

225 Posts

### Re: convert currency to word in crystal report

Mar 02, 2012 02:18 AM|Mahesh Darkunde|LINK

i m giving example ,

Ucase(left(towords({builtydetails.MrAmount}),len(towords({builtydetails.MrAmount}))-13) & " Only.")

if it is work for you plz mark as answer..
• aliyuusman4u

Member

29 Points

114 Posts

### Re: convert currency to word in crystal report

Sir, I am new in crystal report how can i put it as function to be used in the crystal report Thank you sir
• Mahesh Darku...

Member

462 Points

225 Posts

### Re: convert currency to word in crystal report

Mar 02, 2012 02:24 AM|Mahesh Darkunde|LINK

Go to filed explorer and create new Formula filed ,

in that edit formula paste it ..

it sholud be work for you..

if it is work for you plz mark as answer..
• aliyuusman4u

Member

29 Points

114 Posts

### Re: convert currency to word in crystal report

Yes sir, I works thank you somuch i am verry greatful But how can i convert the digit behind the decimal point 100.45 the 45 as cent can i convrt it too? Thank you sir
• Mahesh Darku...

Member

462 Points

225 Posts

### Re: convert currency to word in crystal report

Mar 02, 2012 02:49 AM|Mahesh Darkunde|LINK

use this formula this is the indian currency converter plz chek it in urs..

"Rs. "+ ToWords ({@calculate_TotalAmtwithChrges},0) + " and " +ToWords ((Round({@calculate_TotalAmtwithChrges},2) - Int({@calculate_TotalAmtwithChrges})) * 100, 0) + " Paise only"

if it is work for you plz mark as answer..
• Mahesh Darku...

Member

462 Points

225 Posts

### Re: convert currency to word in crystal report

Mar 02, 2012 02:57 AM|Mahesh Darkunde|LINK

hi aliyuusman4u If U get the answers of ur question then Plz and Plz mark As Answers for this person who gave the answer for your questionss,,,