Thursday, June 2, 2016

Convert Us.Dollar Amount to Word in Crystal Report

Convert  Amount to Word in Crystal Report

--Formula Field Create in Crystal Report

If {@Amt} - int({@Amt}) <> 0 Then
    "US Dollars : " + ProperCase(Towords(int({@Amt}),0)) + " And Cents " +          ProperCase(ToWords(({@Amt} - int({@Amt})) * 100,0)) + " Only."
Else
    "US Dollars : " + ProperCase(Towords(int({@Amt}),0)) + " Only."




No comments: