Symptom
- How to display a number in text? For example: 100, display: One Hundred
- How convert number to multiple languages? For example: English, Spanish, Korean, Arabic,...
- How to convert numeric values to words in different languages on a report in Crystal Reports?
- The function "ToWords" converts a number to words based in the languages selected for the computer regional setting. But how to convert it to multiple languages on the same report in Crystal Reports?
Environment
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
Resolution
- The Crystal Reports function "ToWords" can only convert a number to words in the language selected for the computer regional setting.
- There is unfortunately no options for the function "ToWords" to convert the number in different languages on the same report, like showing the number in English, French, Korean, ...
-
Developer confirmed the ToWords support 15 languages, including:
br - Breton
de - German
en - English
es - Spanish
fr - French
it - Italian
ja - Japanese
ko - Korean
nl - Dutch
pl - Polish
pt - Portuguese
ru - Russian
sv - Swedish
zh_CN - Simplified Chinese (typically used in Mainland China)
zh_TW - Traditional Chinese (typically used in Taiwan)
Keywords
CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020