SCOM 2007: The Scheduled Reports has no graphs, pretty pictures.

I am running SCOM 2007 R2 with CU4 and ‘frigging’ reports doesn’t show pretty pictures.  Well it does show on ad-hot reports, but not in scheduled reports.  After bitching for minute or two, I found the solution from blog from Taiwan CSS Platform Team (Here).

Solution is simple enough. Follow the instructions below to fix it.

• Where is your SQL Reporting Services running? Remote Desktop to that server.
• Open Windows Explorer and go to this location:

<SQL Reporting Services install location>\Reporting Services\ReportServer\bin.

e.g., C:\Program Files\SQL Server\SCOMReporting\Reporting Services\ReportServer\bin.

• Backup ReportingServicesService.exe.config file to safe location. (I would make a copy of file on the same location)
• Open ReportingServicesService.exe.config file in Notepad.
• Find <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
• Paste the following <dependentAssembly> line next to above line.

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>

• Save the file and close Notepad.
• Restart the corresponding SQL Reporting service
• That’s all, generate an schedule report and make a silly dance.