Post reply

Displaying Images in SSRS

  • October 3, 2017 at 11:32 am

    #328940

    We have jpeg images stored under Column 'Content, under Table 'Attachment'.


    Select Statement on the above Table.

    When I take my select statement to SSRS, do an insert image, and call column name 'Content' I am getting an error (small red cross). I think am using the correct mime type for the image as well. Not sure if the problem has to be with the compression. I am using sql server 2012.

    Any advises are appreciated.

  • October 3, 2017 at 2:20 pm

    #1962159

    If the column data is compressed, then it has to be uncompressed before SSRS can understand the data in that column.  How did the data get compressed?

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • October 4, 2017 at 12:46 pm

    #1962337

    You may want to check this thread as someone where someone got this working with a function to decompress as Steve mentions:
    how to show a compressed image in the report?

    Sue

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply