SAP Knowledge Base Article - Public

1891724 - ToWords function displays incorrect output in Polish language in Crystal Reports

Symptom

  • ToWords function output incorrect value.
  • When using the ToWords function in Crystal Reports, it does not always translate the number correctly in Polish language.

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Set the preferred viewing local in Crystal Reports to Polish.
  3. Create a formula using the ToWords function to translate in words a negative value that uses decimals, like:

          ToWords(-5.5)
      
  4. Insert the formula on the report.
  5. When viewing the report, notice the formula output : minus sześć i 50 / 100
    which is incorrect, because if we translate it, it is    : minus six and 50/100

    When the expectation will be to output : minus pięć i 50 / 100
    If we translate it will be                          : minus five and 50/100

Cause

  • The issue occurs mainly with negative numbers with decimal values between 5 and 9, as it seems to round up the value when it should not.
  • The issue has been identified and logged under Problem Report ID ADAPT01699946

Resolution

The issue is resolved in the following product updates:

  • Crystal Reports 2008:
    • Fix Pack 6.3
    • Service Pack 7
               
  • Crystal Reports 2013:
    • Support Pack 03 and above

Keywords

CR, towords, polish, crystal reports, 6.3, SP07, SP03, ADAPT01699946, ADAPT01699947, ADAPT01702788, ADAPT01708083, translate, translation , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 2013