Crystal Report ToWords() Function For Crore and Lac
In order to show a number in words with 'Crore' and 'Lac' you need to create a custom function in Crystal Report. I have a function and it will convert the number with two digit decimal places. Here it is.... numbervar numberValue:=0; numbervar roundedValue:=0; numbervar decimalValue:=0; stringvar inWords:="Tk. "; numberValue := 56080000.34; // You have to put it the number field from database If numberValue >= 10000000 Then (roundedValue := Truncate(numberValue/10000000); inWords := ToWords(roundedValue,0) + " Crore"; numberValue := numberValue - (roundedValue * 10000000)); If numberValue >= 100000 Then (roundedValue := Truncate(numberValue/100000); If Len(inWords) > 0 Then inWor...