Converting Number to words in crystal report

Question

ToWords ({Netpay.NetPay})

i am converting Number to Words in crystal report using formula.

i am using this formula ToWords ({Netpay.NetPay}) output as forty six thousand four hundred ninety two and xx/100.

But i want the output as Forty six thousand four hundred ninety two [ ToWords ({Netpay.NetPay})]

ToWords ({Netpay.NetPay})

In the above formula what change i want to do. to get the output as Forty six thousand four hundred ninety two please help me.

Srisailam ravirala · Answer

numbervar RmVal:=0; numbervar Amt:=0; numbervar pAmt:=0; stringvar InWords := ; Amt := {@UnboundNumber1}; if Amt > 10000000 then RmVal := truncate(Amt/10000000); if Amt = 10000000 then RmVal := 1; if RmVal = 1 then InWords := InWords +   + towords(RmVal0) +  crore else if RmVal > 1 then InWords := InWords +   + towords(RmVal0) +  crores; Amt := Amt - Rmval * 10000000; if Amt > 100000 then RmVal := truncate(Amt/100000); if Amt = 100000 then RmVal := 1; if RmVal >=1 then InWords := InWords +   + towords(RmVal0) +  lakhs; Amt := Amt - Rmval * 100000; if Amt > 0 then InWords := InWords +   + towords(truncate(Amt)0); pAmt := (Amt - truncate(Amt)) * 100; if pAmt > 0 then InWords := InWords +  and  + towords(pAmt0) +  paisa only else InWords := InWords +  only; UPPERCASE(InWords)

venkata kumar · Answer

hi you can add fallowing formula in crystal report upperCase(left(ToWords((({@amt})))length(ToWords((({@amt}))))-12))+ONLY Thanks & Regards Ravi