1864461 - BLOB fields in Crystal Report returns blank data

SAP Knowledge Base Article - Public

1864461 - BLOB fields in Crystal Report returns blank data

Symptom

In Crystal Report, a database field defined as a BLOB fields that contain text/excel file/word document etc. when inserted onto a report does not appear correctly in the report.

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011

Reproducing the Issue

  1. Open the Crystal Report
  2. From "Field Explorer", drag the BLOB Field in the report.
  3. This field (either contain text/ Excel file / Word document etc.) appears as blank in the report.

Resolution

Crystal Report associates BLOB fields with image files. If something other than an image file is in the BLOB field, CR shows the field as a blank.

This behavior is by design.

Note: You can insert an OLE Object in a report to include Excel file, however it will appear as picture format and database field cannot be hyperlinked in crystal Report(or will not open up on clicking) 

Keywords

BLOB field, Crystal report, blank data , 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