Displaying Image from SQL Server in Crystal Reports

Question

Hello,

I have couple of images in my SQL SErver 2008 table of which the datatype is image.

In my VS.net 2008 project I have a crystal report which is displaying all the fileds from that table. But the image is showing as blank.

Any thoughts, How I can make it work?

Answer 1

You have to convert the image before you can show it.

In crystal reports, you can click on the image control and set the value property of the control to the following (replace ImageFieldName with your field name)

System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields!ImageFieldName.Value), 105))

Answer 2

Hi Raj, I have the same problem displaying image in crystal report in .net . I am using the crystal report version 10 comes with .net when I click on the blob field in crystal rteport I can see only oprtion for format object I do not see the option properties and value .Pelase advice .Any help would be apreceated . Thank you