Can't export a report as an Excel workbook when the "Interpret HTML Tags as Styles" option is selected

Applies to: SQL Server 2012 DeveloperSQL Server 2012 EnterpriseSQL Server 2012 Enterprise Core


Consider the following scenario:
  • On a SharePoint site or in Report Manager, you select a Reporting Services report.
  • The report contains a text box in which the HTML option of Interpret HTML Tags as Styles is selected.

When you try to export the report to an Excel workbook, the operation is unsuccessful. Additionally, the following error is logged in the Reporting Services log:
Server Error in '/Reports' Application.

Runtime Error

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

This error is also logged in the Reporting Services log:
Reportrendering!ReportServer_0-2!614!Date time:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: , Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelGenerator.OXML.FatalException: Excel Rendering Extension : Argument is not valid.
at Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.Model.XMLFontRunModel.set_Name(String value)
at Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.Model.XMLFontRunModel.SetFont(XMLFontModel font)
at Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.RichTextInfo.Commit(Style cellStyle)
at Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.OpenXmlGenerator.FinalizeCell()
at Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.OpenXmlGenerator.SetColumnContext(Int32 columnIndex)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.Layout.LayoutEngine.RenderPageToExcel(IExcelGenerator excel, String key, Dictionary`2 sharedBorderCache, Dictionary`2 sharedImageCache)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.MainEngine.RenderRPLPage(RPLReport report, Boolean headerInBody, Boolean suppressOutlines)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)
--- End of inner exception stack trace ---


This issue occurs in the Excel Renderer during parameter validation in the OXML writer. Specifically, this issue occurs if the name of a font in a text box that's HTML-formatted and that includes font instructions for each text run is longer than 31 characters.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Learn about the terminology that Microsoft uses to describe software updates.