Printing calculated amount in words in Crystal Report 8.0
-
Hi everyone, I am working on billing project. I want to print calculated amount in words for Reports. Reports are generated in Crystal Report 8.0 e.g. Amount = 6,45,840/- Rs. In Words “Six Lakhs Forty Five Thousand Eight Hundred Forty Only.” Currently I am using to “towords()” function to convert numeric value to string. Current I am having two problems. 1) Numeric values are not displaying properly values like 6,45,000 are displaying as 645,000. I am not able set thousand separate for values in Lakhs. 2) Words are not correct for values like 100,000 i.e. One Lakh and so on. e.g. If the Amount = 6,45,840/- Rs. It is printing Words as “Six Hundred forty-five thousand eight hundred forty only” Instead of “Six Lakhs Forty Five Thousand Eight Hundred Forty Only.” Please tell me how to solve this problem. I am using Crystal Report 8.0 as Reporting tool and Visual Basic 6.0
Kiran Sajanikar Software Engineer CleverBIT softwares. Pune.
-
Hi everyone, I am working on billing project. I want to print calculated amount in words for Reports. Reports are generated in Crystal Report 8.0 e.g. Amount = 6,45,840/- Rs. In Words “Six Lakhs Forty Five Thousand Eight Hundred Forty Only.” Currently I am using to “towords()” function to convert numeric value to string. Current I am having two problems. 1) Numeric values are not displaying properly values like 6,45,000 are displaying as 645,000. I am not able set thousand separate for values in Lakhs. 2) Words are not correct for values like 100,000 i.e. One Lakh and so on. e.g. If the Amount = 6,45,840/- Rs. It is printing Words as “Six Hundred forty-five thousand eight hundred forty only” Instead of “Six Lakhs Forty Five Thousand Eight Hundred Forty Only.” Please tell me how to solve this problem. I am using Crystal Report 8.0 as Reporting tool and Visual Basic 6.0
Kiran Sajanikar Software Engineer CleverBIT softwares. Pune.
Convert Currency to Words (Indian Format) in Crystal Reports[^]
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007