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. Disappointed smile
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s