Solved

Change number field into words format in crystal report

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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

762 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

20 Experts available now in Live!

Get 1:1 Help Now