Change number field into words format in crystal report

Hi all, currently i need to do a function in Crystal Report to convert a number so that it can display in words. For example, i retrieve a number from database "2200", then this function will convert it to "TWO THOUSAND AND TWO HUNDRED". Crystal report has build-in function to do that? or anyone has done it b4? hope u all can help me on this. ok thanx
WeeKeongAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
If your numbers are integers use

towords({tablename.fieldname},0)

to eliminate the fraction from the end.

mlmcc

0
 
mlmccCommented:
Yes CR has abuilt in function to do this

You need to create a formula using the towords function

Create a new formula like
towords({tablename.fieldname})

Save the formula
Insert the formula in the report


mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.