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