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

Symptoms

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


Cause

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.

Resolution

Update information

This issue is fixed in the following cumulative update for SQL Server:

Cumulative Update 5  for SQL Server 2012 Service Pack 3

Cumulative update 3 for SQL Server 2014 SP2  

Cumulative update 10 for SQL Server 2014 SP1

Cumulative Update 4 for SQL Server 2016

Recommendation: Install the latest cumulative update for SQL Server

Status

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

References

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

ID članka: 3180980 - Poslednji pregled: 17.01.2017. - Verzija: 3

Povratne informacije