At ClearPointe, we provide our managed clients a Web-based portal on which they can view detailed information regarding their servers and devices. Included on each portal is a series of weekly reports generated in Operations Manager 2007 and saved to a network share in .PDF format. The automated process works fine; however, the generated PDF files have not included any of the charts that are rendered when viewed directly from the Reporting space of the Operations Manager 2007 Console.

I spent some time today troubleshooting the problem, initially focusing on SQL Server 2008 Reporting Services as the root of the problem. I soon realized that the problem was not originating with Reporting Services but most likely a configuration issue in OpsMgr Reporting. I began researching that angle and quickly came across the following Microsoft Support article:

http://support.microsoft.com/kb/972821

The support article states that the symptom of the problem is Event ID 108 being logged in the Application event log of the SQL Reporting Services server. The image below was taken directly from our SRS server:

The resolution of the problem involves editing the ReportingServicesService.exe.config file located in the ReportServer\bin directory on the SQL Reporting Services server. Open the file in an editor such as Microsoft Visual Studio Tools for Applications and add the following code between the <assemblyBinding> and </assemblyBinding> tags:

Click to view an enlarged version

Save the changes to the file and restart the SQL Server Reporting Services service. Rerun the report in the Reporting space of the Operations Manager 2007 Console and view the generated .PDF files. The desired charts and graphs are now included in the report.