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.
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.
Recommendation: Install the latest cumulative update for SQL Server
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server: