Print Page | Close Window

how to display blob image from database

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16763
Printed Date: 18 May 2024 at 3:44pm


Topic: how to display blob image from database
Posted By: wangjin
Subject: how to display blob image from database
Date 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.


Replies:
Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window