Have Geek Brain

Displaying an Image from SQL Server in Crystal Reports

I have multiple images in my SQL Server 2008 table that datatype

has image

.

In my VS.net 2008 project, I have a crystal report that displays all fields from this table, but the image is displayed as a blank image.

Any thoughts how I can get it to work?

0


source to share


1 answer


You need to transform the image before you can show it.

In crystal reports, you can click 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))
0


source






More articles:


All Articles