SAP Knowledge Base Article - Public

2971355 - How to convert number to words in different languages on the same report in Crystal Reports?

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