Thursday, June 16, 2011

Crystal Report toWords() function display amount in words with decimal values

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;
deciValue:= Value- Truncate(Value);  //separate decimal value
Value := truncate(Value);
deciValue:= deciValue* 100;
if deciValue= 0 then
propercase(ToWords (Value,0) +' only')
propercase(ToWords (Value,0) + ' And '+ToWords(deciValue,0) + ' Paisas Only ')

here is the output for 2222.44


Postman beginner Tutorial

Hi , I have started new video series of postman tutorial hope it will be helpful:Please give me your feed back in comments and like and sub...