Displaying photos

[Guest_imported]

What is the mechanism to display the photos stored in a table through Crytal Reports ?

 

[kenhamady]

Are the photos truly stored in the table (as BLOB objects)? or is the path stored in the table.

If the field is a blob, you can simply put that field on the report. If it is a path, there is no way in CR to have it return the object from the path in each record. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[carloalexi]

I had the same problem, the solution occurred to me after reading another post from someone who got it to work with BMPs but could not with JPGs or GIFs.

Since I was storing image data only from JPG files (which are smaller), I tried storing binary data from BMPs instead and it worked. For confirmation, I tried storing some BMPs and some JPGs and Crystal Reports only displayed the BMPs.

I have only tested this using an ODBC connection to SQL Server 7 (it should work with other ODBC sources)