Skip to Content
0
Former Member
Apr 26, 2015 at 06:51 AM

Need to get decimal place appear in words in crystal report

660 Views

Hi Experts

i had created a report in which, total value need to be shown in Words

but when i created a formula, the decimal place is not showing only the round figure is appearing

for eg : if the total amount is 200.04

in words it appears only SAR Two Hundred Only

i need it to be appear as SAR Two Hundred and Zero Four Halal Only

The below given is the formula

"SAR" +" "+ProperCase (towords ({#Cr.Total},0.0))+" "+"Only"

Regards