SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
     
  • 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 MS ODBC Data Source Administrator ( 32 bit )
    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 BusinessViews Manager , Problem

Product

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