I have seen articles that seem like it is possible to add an image that is in a SQL database (image is in the database) to a Crystal report. I currently am using 11.5.8.826.

Not sure where to even start with this. I am connecting directly to the SQL database from Crystal.

I've tried that and it didn't work.  When I look at the SQL database it the content_type is image/jpeg.

I'm trying to add an image  - go to the format editor for the picture - picture tab - and add a BLOB there.  I just don't know how to write this out..... any ideas? 

I have this but Crystal Reports does not recognize this....


System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields!{photos.base64}.Value), 105))




Edited by chudok - 10 Jul 2012 at 9:43am

Hmmm.... I've never had problems getting the image to show through an OLEDb connection (or through a native Oracle connection, but you're not connecting to Oracle.)It's been several years since I've worked in Crystal XI, so I'm not sure whether this will work....

I have this but Crystal Reports does not recognize this.... System.Convert.FromBase64String(Mid(System.Convert.ToBase64String (Fields!{photos.base64}.Value), 105)) Edited by chudok - Yesterday at 9:43am
________________________________________
led spot light    
http://www.ledlightssell.com/led-spotlight-c-231.html

Yea - this is what I received back from the developer.  I was under the impression at first we could do it right from the DB but, it looks like we have to do a little work to get it up and running.   Thank you for your help.  I wish it would of been that easy for me, but it looks like it can be done, just have to do a little extra work to get it to work.

See notes below....

Unfortunately, no matter how we save the images to the DB, you will always need some script to display it.  The way it currently is, you can use a simply SQL Function to decode your images from its Base64 encoding.  Here is an example:

 

CREATE FUNCTION [dbo].[base64_decode] (@base64_text VARCHAR(max)) RETURNS

VARBINARY(max)

    WITH SCHEMABINDING, RETURNS NULL ON NULL INPUT BEGIN

    DECLARE @x XML; SET @x = @base64_text

    RETURN @x.value('(/)[1]', 'VARBINARY(max)') END GO