Number to Text Crystal Report | Techbymati
please try this, 1st you create a formula : NumToWords1
towords(truncate(sum({C_PaymentItem.AMOUNT}),0))
after that the second formula: NumToWords1
if Round({@Total Amount},2) - Int({@Total Amount}) = 0 then
"Ringgit Malaysia: " + ToWords ({@Total Amount},0) + " only"
else
"Ringgit Malaysia: " + {@NumToWords1} + " and " + "Cents " + ToWords ((Round({@Total Amount},2) - Int({@Total Amount})) * 100, 0) + " only"
Tags:
Software