SAP Knowledge Base Article - Preview

2666742 - In CR4Eclipse, when we run a report that has a column defined as Numeric (5, 0) or Decimal (5, 0), not all the values are displayed correctly

Symptom

  • In CR4E v2 SP 19, 20 and 21 when we run a report that has a column defined as Numeric (5, 0) or Decimal (5, 0) not all the values are displayed correctly. For example the value 32768 get displayed as -32768. Value 32769 gets displayed as -32767. Basically any number > 32767 has this issue. We run the reports against a DB2 database running on an IBM iSeries server.
  • Create a very simple table and loaded it with data. Here is an example table:
  • CREATE TABLE MYTEST
    (
    TEST01 NUMERIC ( 5, 0) NOT NULL WITH DEFAULT,
    TEST02 NUMERIC ( 6, 0) NOT NULL WITH DEFAULT,
    TEST03 INTEGER NOT NULL WITH DEFAULT,
    TEST04 DECIMAL (5 , 0) NOT NULL WITH DEFAULT
    )
  • Below are the results. Notice how column TEST01 and TEST04 are displayed incorrectly. Compare columns TEST01 to TEST02. The data in TEST02 are correct, but the data in TEST01 with the exact same data is incorrect.


Read more...

Environment

  • SAP Crystal Reports, version for Eclipse SP22
  • SAP Crystal Reports runtime engine to Java application, version 12.2.223

Product

Crystal Reports, version for Eclipse 2.0

Keywords

cr4e, Numeric (5, 0), Decimal (5, 0), field definition , KBA , BI-RA-CR-ECL , Crystal Reports for Eclipse , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.