Skip to main content
Nintex Community Menu Bar
Solved

Show image from K2 Image Attachment control on SSRS report

  • October 18, 2018
  • 2 replies
  • 27 views
  • Translate

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)

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img+15

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

Translate

Forum|alt.badge.img+3
  • Rookie
  • 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)

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings