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."
--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:
Post a Comment