I have to display amount in Words with decimal values in my report for achieving this i wrote small formula in Crystal Report
here is the formula:
numbervar Value;
numbervar deciValue;
Value:={ES_RPT_SP_AdvPaymentPRC;1.RECEIVED_AMOUNT};deciValue:= Value- Truncate(Value); //separate decimal value
Value := truncate(Value);deciValue:= deciValue* 100;
if deciValue= 0 then
propercase(ToWords (Value,0) +' only')else
propercase(ToWords (Value,0) + ' And '+ToWords(deciValue,0) + ' Paisas Only ')
Hi, thank you very very much; helped me a lot!!!
ReplyDeleteYou are welcome :)
DeleteYou are Really Great, this is the smallest Code I come across.
ReplyDelete