Solved

Change number field into words format in crystal report

Posted on 2002-04-18
2
478 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 100

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 100

Accepted Solution

by:
mlmcc earned 150 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

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. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

813 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now