Converting number to words in Crystal Reports

crystal-reports formula
Sensa picture Sensa · Apr 12, 2012 · Viewed 40.1k times · Source

How can you convert a number to its written-equivalent in a formula?

For example, 10000 is converted to Ten Thousand.

Answer

craig picture craig · Apr 13, 2012

You want to use the ToWords() and ProperCase() functions.

//{@Convert}
// returns Ten Thousand
ProperCase( ToWords(10000, 0) )

Related questions

Crystal reports suppression formula with multiple OR operators not working

I am trying to add a very simple suppression formula to my Crystal Report (XI) field but it is not working as expected. I would like a text box to be visible if certain conditions are met, otherwise suppress. With …

Read More
Padding a fixed number with leading zeros up to a fixed length

In Crystal Report using Visual Studio 2010, I am trying a to create a formula for the following scenario: x = any number (Fixed number of 8 digits, cant be less or greater) If Length of X is less than 8, pad the required …

Read More
Crystal Report: How to evaluate multiple IF statements in one formula?

Background I'm attempting to do some nice looking validation on the details row of my report. I have several formulas named as Assert statements, that return false if they fail a test and true if they pass. Goal I would …

Read More