How to convert Amount in Words using Crystal Report?

Posted by Laghaterohan under Regular Expressions on 11/16/2010 | Points: 10 | Views : 28935 | Status : [Member] | Replies : 2
Hello,

Can any one let me know how to convert Amount in INR into Words using Crystal Report??

I am using TOWORDS function for the same in crystal reports however it is not working properly.

If i use TOWORDS(2) It gives me output as 2 and xx/100 ...
so if i use TOWORDS(2,0) It gives me 2 ...which is correct however i can't use then values with decimal.

Secondly, if i have values in lakh it does not display amount properly.

Please can any one let me know how to get it working???

Thanks!!

Best Regards,
Rohan Laghate



Responses

Posted by: Lalji_mer on: 11/17/2010 [Member] Bronze | Points: 25

Up
0
Down
Hi,

Good Morning.

create a formula and insert a formula like:

ToWords ({Employees.EmployeeID},0)

then place it in your report.

This will display the number in words with no decimal places. If you want decimals change the ",0"

Look here good article for convert Amount in Words using Crystal Report in vb.net
http://www.dotnetspider.com/resources/5462-How-Convert-Rupee-Value-Words-using-VB-NET.aspx

More about will help
http://www.eggheadcafe.com/community/aspnet/14/10016462/how-to-change-number-into-words-in-crystal-reports.aspx

Here converter will help you

http://converter.telerik.com/Default.aspx

LP MER

Laghaterohan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: T.saravanan on: 11/18/2010 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi,

Try the following links....

http://www.allinterview.com/showanswers/116424.html

http://social.msdn.microsoft.com/Forums/en/vscrystalreports/thread/5e2c8681-9d7d-4731-848e-d0e2cc8aa0b7

Cheers :)

Thanks,
T.Saravanan

Laghaterohan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response