0
Reply

curency conversion in crystal report

chandu gummadi

chandu gummadi

Feb 4 2013 12:14 AM
1.3k
hi friends iam using towards function in crystal reports for to display the 150000
" one lakh fiftythousend rupees only"

iam using bellow formula but it shows A number,currency amount, boolean, date,time, or string is expected here..

numbervar RmVal:=0;
numbervar Amt:=0;
numbervar pAmt:=0;
stringvar InWords :="Rupees ";
Amt := tonumber({@net_sal});
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);
if Amt = 100000 then RmVal := 1;
if RmVal =1 then
InWords := InWords + " " + towords(RmVal,0) + " 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(pAmt,0) + " paisa only"
else
InWords := InWords + " only";
UPPERCASE(InWords)