OpsMgr scheduled reports work but no graphics?

I was working on scheduled report delivery by SQL Reporting Services in 2008 within Operations Manager 2007 R2 but when they showed up the charts in the attachment were blank.

NOTE: If you are going to email enable the report you need to configure the E-Mail settings in the Reporting Services Configuration Manager or the option to email will not appear when you attempt to schedule a report for delivery.

I tried multiple formats (Adobe, Word, HTML) but each was missing the graphics. I found the KB article on this (http://support.microsoft.com/kb/972821) but these reports were still delivering without the graphics. The KB mentioned the addition of information into the ReportingServicesService.exe.config file in the ReportServer\bin directory however it appears that my XML hacking brain was disconnected when I started with this. So for the XML challenged in the room, the first figure shows the correct location to put the XML they are referencing in this KB article.

01

The XML the KB references adding is:

<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>

To verify that the change has taken effect stop and restart the Report Server with the Stop and Start buttons shown below. If the XML was incorrectly changed (hint-hint) the service will not fail to start. After successfully changing the XML and restarting the services my scheduled reports started delivering with the attachments showing the graphics correctly.

02 stop and start to verify

Leave a Reply

OpsMgr scheduled reports work but no graphics?

I was working on scheduled report delivery by SQL Reporting Services in 2008 within Operations Manager 2007 R2 but when they showed up the charts in the attachment were blank.

NOTE: If you are going to email enable the report you need to configure the E-Mail settings in the Reporting Services Configuration Manager or the option to email will not appear when you attempt to schedule a report for delivery.

I tried multiple formats (Adobe, Word, HTML) but each was missing the graphics. I found the KB article on this (http://support.microsoft.com/kb/972821) but these reports were still delivering without the graphics. The KB mentioned the addition of information into the ReportingServicesService.exe.config file in the ReportServer\bin directory however it appears that my XML hacking brain was disconnected when I started with this. So for the XML challenged in the room, the first figure shows the correct location to put the XML they are referencing in this KB article.

01

The XML the KB references adding is:

<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>

To verify that the change has taken effect stop and restart the Report Server with the Stop and Start buttons shown below. If the XML was incorrectly changed (hint-hint) the service will not fail to start. After successfully changing the XML and restarting the services my scheduled reports started delivering with the attachments showing the graphics correctly.

Leave a Reply