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.
- SAP Crystal Reports 2008
- SAP Crystal Reports 2011
Reproducing the Issue
- Open the Crystal Report
- From "Field Explorer", drag the BLOB Field in the report.
- This field (either contain text/ Excel file / Word document etc.) appears as blank in the report.
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)
BLOB field, Crystal report, blank data , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem