Skip to main content
Nintex Community Menu Bar
Solved

Show image from K2 Image Attachment control on SSRS report

  • October 18, 2018
  • 2 replies
  • 56 views

Forum|alt.badge.img+3

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.

Best answer by bsimon89

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)

2 replies

Forum|alt.badge.img+15

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


Forum|alt.badge.img+3
  • Author
  • Rookie
  • Answer
  • October 19, 2018

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)