SAP Knowledge Base Article - Public

1909574 - No picture displays on the report when reporting of Informix in Crystal Reports

Symptom

  • No images.
  • Pictures stored in Informix data source doesn't display on reports.
  • No pictures displayed when reporting of an Informix data source in Crystal Reports.

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
     
  • Informix

Reproducing the Issue

  1. In MS ODBC Data Source Administrator, create an ODBC connection to an Informix data source using the IBM Informix ODBC driver.
  2. In Crystal Reports, create an ODBC connection to the Informix data source that contains pictures.
  3. Add the database field that contains the pictures to the report.
  4. Refresh the report, and notice there is no pictures displaying on the report.

Cause

  • No pictures displays on the report because the IBM Informix ODBC driver does not return standard ODBC types by default.
       
  • When connecting to data source via an ODBC connection, Crystal Reports uses standard ODBC calls, and since the data type sent from the IBM Informix ODBC driver is not returning a standard data types, it is then not possible to recognize that the database fields actually contains pictures, and therefore it displays nothing on the report.

Resolution

  • Configure the ODBC DSN defined on the IBM Informix ODBC Driver to use Standard ODBC Types.
      
    1. Open the Microsoft ODBC Data Source Administrator:

      • For Crystal Reports 2011, 2013, 2016: 
        Open the 32bit Microsoft ODBC Data Source Administrator.

      • For Crystal Reports 2020: 
        Open the 64bit Microsoft ODBC Data Source Administrator.
             
           
    2. Select the ODBC DSN that connects to the Informix data source using the IBM Informix ODBC driver, and click on the "Configure" button.
       
      KB01.png
         
        
    3. In the "IBM Informix ODBC Driver Setup" window, under the tab "Advanced", check the option:

      "Report Standard ODBC Types Only"
         
       
      KB02.png
       
       
    4. Click "OK" to accept the change.
        
      Now, when refreshing or creating a new report off Informix in Crystal Reports, it will displays pictures.

Keywords

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

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020