TIFF Image in SSRS Report
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 I created a SP which reads the image from a shared path & stores the image in a temp table as Image data type The SP then returns the temp table in the result set I created a blank report in BIDS (SQL Server 2008 R2) I then created a data set on the report with the SP created I added an Image object on the report I set Image source = Database I set the field to be used as the bytes field in the dataset 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)
September 13th, 2011 1:49am

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.
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2011 4:05am

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.
September 14th, 2011 5:03am

Thanks Lola!
Free Windows Admin Tool Kit Click here and download it now
September 15th, 2011 6:29am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics