Display numbers into words in indian format

Question

i used the bellow formula for disply laksh in crystal reports . but it returns 'hundred' for 'lakh'.
for e.g. i have used towords formula on 738195.12,and the output is 'Rupees seven hundred thirty-eight thousand one hundred ninety-five and twelve'. what should i do now???

if
right(Totext({amount}),2)="00"
then
uppercase(ToWords({amount},0))+" "+"Only"
else
uppercase(ToWords({amount},0))+" AND "+uppercase(ToWords(tonumber(right(Totext({amount}),2)),0))+" "+"Paisa Only"

Fathima Jabbar · Answer

Hi, You could create a running total field for summing up and pass it in the formula. This worked for me. You check it.

Prasad Bhagat · Answer

Dear madam, Thankyou for your reply but madam still iam having same prob becoz i don't have database field a have a sum field in that crystal report so it was getting same error if possible please help me

Fathima Jabbar · Answer

Hi Prasad, You could create a formula field for converting number to words. Hope the following sample could help you. numbervar RmVal:=0; numbervar Amt:=0; stringvar InWords :=""; Amt := {Command.DB_FIELD}; // you can pass your db field here. if Amt > 10000000 then RmVal := truncate(Amt/10000000); if Amt = 10000000 then RmVal := 1; if RmVal = 1 then InWords := InWords + " " + towords(RmVal,0) + " crore" else if RmVal > 1 then InWords := InWords + " " + towords(RmVal,0) + " crores"; Amt := Amt - Rmval * 10000000; if Amt > 100000 then RmVal := truncate(Amt/100000) else if Amt = 100000 then RmVal := 1; if RmVal = 1 then InWords := InWords + " " + towords(RmVal,0) + " Lakhs" Else if RmVal > 1 then InWords := InWords + " " + ToWords(RmVal,0) + " Lakhs"; Amt := Amt - Rmval * 100000; if Amt > 0 then InWords := InWords + " " + towords(truncate(Amt),0); InWords := InWords + " only"; UPPERCASE(InWords) Regards, Fathima Jabbar.

Prasad Bhagat · Answer

Dear Vithal Wadje, Thanks for your reply but my question is disply the numbers into words incrystal reports not in c#, and i want disply a number 122202 value into words like one lakh twenty two thousend two hundred and two rupees while displying the words iam passing not a number iam passing a field like sum field some other portals are showing some code but it has to be pass a number insted of that i want pass a field if possible let me know

Vithal Wadje · Answer

refer my article http://www.c-sharpcorner.com/UploadFile/0c1bb2/converting-a-number-to-string-in-Asp-Net-and-C-Sharp/

Display numbers into words in indian format

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)