Report Designer: Error When Running a Report

Summary:

When a user attempts to run a report in Excel, the report errors out.

Symptoms:

There was a problem rendering this report.

System.Runtime.InteropServices.SEHException (0x80004005): External component has thrown an exception.

   at Microsoft.Office.Interop.Excel._Application.CalculateFull()

   at OneStop.ReportPlayer.SheetWriter.ScreenUpdate(Boolean turnOn)

   at OneStop.ReportPlayer.SheetWriter.RenderReport(ExecuteResult result, PublishType publishType, String password, ProgressChangedEventHandler progressChanged)

   at OneStop.ReportPlayer.ReportManager.RenderReport(ExecuteResult result, PublishType publishType, ProgressChangedEventHandler callback)

   at OneStop.ReportPlayer.Forms.RunPane.

OSR Version: 4.6.31208.1024

The user running the report fits all the system requirements and is on Windows 10.

Cause:

On older versions of Windows 10, there is an issue with rendering the report. This has been documented in at least 3 tickets where the clients were on version number 1511 or older of Windows 10.

Resolution:

On older versions of Windows 10, there is an issue with rendering the report. This has been documented in at least 3 tickets where the clients were on version number 1511 or older of Windows 10.

Simply updating Windows 10 to the latest version will fix this issue. There is no need to reinstall Excel or Reporting. At the time this article was written, version 1709 was the latest build of Windows 10.

Properties:

Applies To:

• Report Designer 4x