Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 SSRS 2005. Excel option not appearing in export dr

Author  Topic 

theboyholty
Posting Yak Master

226 Posts

Posted - 2010-06-14 : 10:12:02
Using reporting services 2005 and today, there's no Excel option in the drop down list when you choose to export the report.

I've logged onto the offending webfarm and Event Viewer has told me that the error is "Report Server Windows Service (RS2005) cannot load the EXCEL extension".

The Reportserver.config file has the reference to the extension file, "<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>" and the rendering extension file itself exists.

I'm going to Restart the webfarm tonight and I hope that will solve it but this is the second time this has happened and I want to know why.


---------------------------------------------------------------------------------
http://www.mannyroadend.co.uk The official unofficial website of Bury Football Club
   

- Advertisement -