Solved

Show image from K2 Image Attachment control on SSRS report

  • 18 October 2018
  • 2 replies
  • 2 views

I've got a form that captures images and stores them in a nvarchar(max) column in SQL.  For some reason I'm spacing on how to display this image on an SSRS report.  I know I've seen this done before, but can't figure out what I'm missing.

 

The image is being stored in SQL  in the following format - <image><name>Imagename.jpeg</name><content>imagecontentgoeshere</content></image>.  I can pull that field into SSRS, and use this field to populate the value behind an image control.  On the image control, I'm setting the source to database.  I've tried all sorts of file types/mime types, but can't seem to get anything but a red 'x' to show up.

 

Any hints would be great.  Thanks.

icon

Best answer by bsimon89 19 October 2018, 14:02

View original

2 replies

Can you attach a screenshot showing how you set the value in your image attachment control?

I was able to resolve this by extracting the data between the <content> tags in the SQL query inside my SSRS dataset.  Once there, I set the value of the image control with =CONVERT.FROMBase64String(Fields!fieldnamegoeshere.Value)

Reply