Print Page | Close Window

VB-2005 Crystal Reports Photo from Database

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19119
Printed Date: 01 May 2024 at 2:51pm


Topic: VB-2005 Crystal Reports Photo from Database
Posted By: zoormoor
Subject: VB-2005 Crystal Reports Photo from Database
Date Posted: 15 Feb 2013 at 12:23am
I Would like to show employees photos in Crystal Reports from SQL Server 2005 Table using VB-2005 but unable to achieve result

Database: SQL Server 2005
TableName: Employees
Column Name: photo
Column Type: image
Language: VB-2005

The Crystal Reports would be based on DataSet [ReportDataSet] and i am trying to store the image in [photo] column of DataTable [Table001]

DataSet: ReportDataSet
DataTable: Table001
ColumnName : photo
DataType: Byte

I have spent almost 3-4 hours but unable to achieve result....

kindly guide / help to achieve result?


Replies:
Posted By: hilfy
Date Posted: 18 Feb 2013 at 6:44am

I've had the best results working with images in JPEG formats directly from image fields in the database.  I'm not sure whether this will work from a Data Set.

 
Whay type of image is the photo?
 
-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