Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: how to display blob image from database Post Reply Post New Topic
Author Message
wangjin
Newbie
Newbie


Joined: 08 Jan 2011
Online Status: Offline
Posts: 3
Quote wangjin Replybullet Topic: how to display blob image from database
    Posted: 15 Jun 2012 at 2:21pm
I'm trying to include a BLOB field in one of my reports but the field appears as empty . How can I make signature image display on report?
I used command to do the query:
select signature from validsinature where signaturecode =1
(The signature is the column in MSSQL 2005. It stores *.jpg as blob.)
I drag the column from database fields panel onto design panel. Preview it, signautre image does not display(empty).
Crystal Reports 2008
Database: Remote mssql 2005 database
Connection method: JDBC conn
Type of data in the BLOB is JPG file.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 18 Jun 2012 at 4:21am
.JPG formatted images in the database should show up.  It might be due to the JDBC connection type.  I would try connecting using an OLEDb connection and see whether that works.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.