SAP Knowledge Base Article - Public

1845692 - Images defined as varbinary in MS SQL Server 2008 do not display in a Crystal Report

Symptom

  • When using  Microsoft JDBC Driver to connect to MS SQL 2008 images do not show up

Environment

Cause

  • The following table structure is used:

 

UserID int
BLOBData varbinary
UpdateDate datetime

Resolution

  • The datatype (SQL type) must be defined as image and not as varbinary

Keywords

pic picture var binary , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011