locked
TIFF Image in SSRS Report RRS feed

  • Question

  • My requirement is to display a TIFF image on a SSRS report.

    As SSRS Report Image object does not allow TIFF image format I have done the following work around

    1. I created a SP which reads the image from a shared path & stores the image in a temp table as Image data type
    2. The SP then returns the temp table in the result set
    3. I created a blank report in BIDS (SQL Server 2008 R2)
    4. I then created a data set on the report with the SP created
    5. I added an Image object on the report
    6. I set Image source = Database
    7. I set the field to be used as the bytes field in the dataset
    8. I set MIME type = Image/jpeg

    After running the report, the image was getting displayed on the report as expected.

    I then deployed the report on SSRS 2008 R2 server

    The problem is that the image is not getting displayed on the deployed report. (a cross symbol is getting displayed)

     


    Tuesday, September 13, 2011 5:47 AM

Answers

  • Hi A4Aki,

    By design, the image control in Reporting only supports BMP, JPEG, GIF and PNG image formats. Even though you can display Tiff image(Stored in database) in VS develop environment, Report Server still cannot support it.

    This is a known issue as described in this thread: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/8085bc45-d4f5-46eb-9999-16b0da2e4af8

    However I suggest you to submit a wish at https://connect.microsoft.com/SQLServer/, and our engineers will take it into consideration. Your feedback is valuable for us to improve our products and increase the level of service provided. We appreciate your understanding. If you have any question, please feel free to ask.

    Thanks,
    Lola Wang


    Please remember to mark the replies as answers if they help.
    • Marked as answer by Lola Wang Thursday, October 6, 2011 9:55 AM
    Wednesday, September 14, 2011 9:02 AM
  • I think there is some problem in Report Manager's Report Viewer control.

    I used the same report which is deployed on the web server in a windows application & its working.

    I created a windows application, added a report viewer control & set the report viewer to point to the report deployed on the SSRS 2008 R2 server.

    The image is getting displayed on the report without making any changes to the report.

    • Marked as answer by Akash Dhawale Thursday, September 15, 2011 10:15 AM
    Tuesday, September 13, 2011 8:02 AM

All replies

  • I think there is some problem in Report Manager's Report Viewer control.

    I used the same report which is deployed on the web server in a windows application & its working.

    I created a windows application, added a report viewer control & set the report viewer to point to the report deployed on the SSRS 2008 R2 server.

    The image is getting displayed on the report without making any changes to the report.

    • Marked as answer by Akash Dhawale Thursday, September 15, 2011 10:15 AM
    Tuesday, September 13, 2011 8:02 AM
  • Hi A4Aki,

    By design, the image control in Reporting only supports BMP, JPEG, GIF and PNG image formats. Even though you can display Tiff image(Stored in database) in VS develop environment, Report Server still cannot support it.

    This is a known issue as described in this thread: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/8085bc45-d4f5-46eb-9999-16b0da2e4af8

    However I suggest you to submit a wish at https://connect.microsoft.com/SQLServer/, and our engineers will take it into consideration. Your feedback is valuable for us to improve our products and increase the level of service provided. We appreciate your understanding. If you have any question, please feel free to ask.

    Thanks,
    Lola Wang


    Please remember to mark the replies as answers if they help.
    • Marked as answer by Lola Wang Thursday, October 6, 2011 9:55 AM
    Wednesday, September 14, 2011 9:02 AM
  • Thanks Lola!
    • Proposed as answer by McMalakai Wednesday, December 5, 2012 11:42 PM
    • Unproposed as answer by McMalakai Wednesday, December 5, 2012 11:43 PM
    Thursday, September 15, 2011 10:28 AM