?
Solved

Change number field into words format in crystal report

Posted on 2002-04-18
2
Medium Priority
?
486 Views
Last Modified: 2006-11-17
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
0
Comment
Question by:WeeKeong
  • 2
2 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 6950495
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
 
LVL 101

Accepted Solution

by:
mlmcc earned 600 total points
ID: 6950507
If your numbers are integers use

towords({tablename.fieldname},0)

to eliminate the fraction from the end.

mlmcc

0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question