cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports Does not work with BLOB data (Image - Varbinary) - JDBC - SQL Server

Former Member
0 Kudos

We have an image stored in SQL Server Version 2012 and that needs to be displayed in a crystal report through a JDBC Driver.

This is NOT working with Microsoft JDBC Driver.

Environment used:

1.     OS: XP OR Windows Server 2012

2.     SQL Server version : SQL Server 2008 or SQL Server 2012.

3.      JDK Version 7 - Update 10.

4.     JDBC Driver : Ver 4 downloaded form http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

5.     A simple  Table structure as follows.

UserIDint
BLOBDatavarbinary
UpdateDatedatetime

This is not working on Crystal Reports Viewer 2011 as well.

Not working meaning, i am not able to see the picture.

Within the report the field is seen as String.

The same field works fine if I use other drivers like JTDS 1.3. But JTDS driver has other bug that prevents us from using the same.

Any Help is appreciated.

TIA

Dr.R.Giridharan

View Entire Topic
Former Member
0 Kudos

Hi Raghavan,

What is the version of Crystal Reports designer being used.What is the size of images held by this blob field.Does it show up correctly in some other application than Crystal Reports.

If there is no specific dependence on using JDBC, is there a chance to test this with Crystal Reports 2008/11 on SQL Server 2008 and OLEDB / ODBC connection using the SQL Server Native Client 10.0 driver.

Alternatively,dynamic linked OLE objects can be used to pick up the images from a local/network folder-file path. Information about this will be available in the Crystal Reports 'Help' menu.

Thanks,

Prathamesh

Former Member
0 Kudos

Thanks for your reply.

We are using CR 2011 IDE and images of all sizes and types like JPG, gif and png were tried. But no fruitful result.   However, when we modified the driver to MS JDBC driver (ver 4). It started working.

It is not an embedded object but a plain image placed in the report like affixing a company logo / stamp/ signature dynamically.

Former Member
0 Kudos

One additional Info, who ever is trying to use MS JDBC, with images. These images would work only if the datatype (SQL type) is defined as image and not as varbinary (as used in JTDS driver).

Former Member
0 Kudos

Thanks Raghavan for sharing this information. Could you close this thread as answered (by yourself).

-Prathamesh

Former Member
0 Kudos

Thanks for your reply,

Not sure how to close the thread

abhilash_kumar
Active Contributor
0 Kudos

Don't worry, you've already closed the thread by marking it as Answered.

Thanks!

-Abhilash