SAP Knowledge Base Article - Public

3769148 - Crystal report does not display null value correctly after upgrading to Crystal Reports 2020

Symptom

When there is an empty value in the crystal report, it is showing the previous row's value after upgrading to Crystal Reports 2020.

Environment

  • SAP Crystal Reports 2020
  • SAP Crystal Reports 2025
  • DB2 11.5 version
  • DB2 11.5 ODBC driver

Reproducing the Issue

  1. Open Crystal Reports 2020.
  2. Create a report based on DB2.
  3. Observe instead of a null value, the previous row's value appears.

Cause

  • The DSN Driver for ODBC was changed to DB2CLI64.DLL from DB2CLIO.DLL.
  • DB2CLI64.DLL driver is needed for DB2 native connection ("DB2 Unicode") instead of an ODBC connection.

Resolution

To change back to DB2CLIO.DLL the DSN Driver:

  1. Go to regedit HKEY_LOCAL_Machine-> Software-> ODBC-> ODBC.INI -> {Name of your DSN}
  2. Change value Driver from DB2CLI64.DLL to DB2CLIO.DLL.
  3. Restart Crystal Reports.

See Also

DB2CLI64.DLL DB2CLIO.DLL crystal DB2 odbc dsn empty null value

Keywords

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2020 ; SAP Crystal Reports 2025