Cameron Fuller
Cameron is a principal consultant for Catapult Systems. A Microsoft MVP (SCOM), Cameron blogs about infrastructure topics including SCOM, virtualization, Exchange and Active Directory. Cameron is a MCTS for SCOM and SCCM.

OpsMgr scheduled reports work but no graphics?   

Tags: OpsMgr and MOM
Technorati Tags:

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

 
Posted by  Cameron Fuller  on  6/14/2010
3  Comments  |  Trackback Url  | 0  Links to this post | Bookmark this post with:        
 

Comments


chris  commented on  Monday, September 27, 2010  6:41 AM 
Check this sentence:

"If the XML was incorrectly changed (hint-hint) the service will not fail to start."


Mike  commented on  Tuesday, February 22, 2011  1:07 PM 
Thanks for this post! I found the KB article but it wasn't obvious where to put the new lines and since I'm not SQL expert this really helped.


jeff  commented on  Tuesday, May 17, 2011  9:19 AM 
Hey!

This workaround didn't work for me.
I've changed the config file, started the ReportServer but qhen I scheduled a report, no mail was sent (notice that with the original xml the mail is sent normally).

One thing I noticed in my xml config file is this part:

<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.ReportingServices.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral" />
<bindingRedirect oldVersion="8.0.242.0" newVersion="9.0.242.0" />
</dependentAssembly>
</assemblyBinding>

That is different from your's because of the versions.. should it be the problem?

Thanks in advance.

Name *:
URL:
Email:
Comment:


CAPTCHA Image Validation