Data Management

Troubleshooting tip: When images don't display in SQL Reporting Services Scheduled Reports

Brad Bird ran into a problem with broken images in Scheduled Reports using SQL Reporting Services. He shares the solution in this troubleshooting tip.

Recently, I ran across an issue using Microsoft's System Center Operations Manager (SCOM) 2007 R2, which plagued me for over a week, and nobody seemed to have an inkling how to help. I found that once a SQL Reporting Services report is deployed using Scheduled Reports (Figure A), there are no images, as you can see in Figure B.

Figure A

Scheduled Reports console (click to enlarge)

Figure B

Report with broken images

If this report is run manually, all data shows up just fine:

Figure C

The error is reported in the SQL ReportServer Application log:

Figure D

After puzzling over this for awhile, I finally found a solution in a Taiwan CSS Platform Team Technet blog. The code mod snippet below is the solution:

Solution ===========

To resolve this problem, add the following information to the ReportingServicesService.exe.config file in the ReportServer\bin directory:

<dependentAssembly>

<assemblyIdentity name="Microsoft.ReportingServices.ProcessingCore" publicKeyToken="89845dcd8080cc91" culture="neutral" />

<bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0" />

</dependentAssembly>

<dependentAssembly xmlns="urn:schemas-microsoft-com:asm.v1">

<assemblyIdentity name="Microsoft.ReportingServices.ProcessingCore" publicKeyToken="89845dcd8080cc91" culture="neutral" />

<bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0" />

</dependentAssembly>

I only found out my change worked because an admin who receives these reports via email sent me a thank you message. My initial testing did show that the change worked when delivered to a file share. The errors were no longer present in the event logs.

My issue has to do with the file format and the type of delivery that I had selected, shown in Figure E.

Figure E

I picked HTML 4.0 as the render format, which does not deliver the report in a single file. According to the MSDN Library reference:

For file share delivery, choose a format that delivers the report in a single file, where all images and related content are included in the report. Suitable formats include Web archive, PDF, TIFF, and Excel. Avoid HTML4.0. If your report includes images, the HTML 4.0 formats will not include them in the file.

See this link above for more details. Variations of this problem could appear in any program which leverages SQL Reporting Services. I hope this post helps someone get to a quicker solution than I did!

About Brad Bird

Brad Bird is a lead technical consultant and MCT certified trainer based in Ottawa, ON. He works with large organizations, helping them architect, implement, configure, and customize System Center technologies, integrating them into their business pr...

Editor's Picks

Free Newsletters, In your Inbox