[Solved] Excel report failing

[Kori]

Suddenly, it looks like we're having issues generating excel reports possibly when the reports reach a certain size. We updated to the latest reporting version, 20.1.26.520, it's exclusively excel and of the old XLS format.

System.ArgumentException: Destination array was not long enough. Check destIndex and length, and the array's lower bounds.
   at void Array.Copy(Array sourceArray, int sourceIndex, Array destinationArray, int destinationIndex, int length, bool reliable)
   at void Array.CopyTo(Array array, int index)
   at INSTINF[] Telerik.Reporting.Excel97.SST.WriteRecordAndGetOffsets(Stream stream, uint sSTAddress)
   at void Telerik.Reporting.Excel97.Workbook.CreateSSTandEXTSSTRecords(Stream stream)
   at void Telerik.Reporting.Excel97.Workbook.WriteWorkBookRecords(Stream stream, ICollection<long> boundSheetAddresses)
   at void Telerik.Reporting.Excel97.Workbook.Save(Stream stream)
   at bool Telerik.Reporting.ExcelRendering.Excel97.ExcelReport.Telerik.Reporting.Processing.IRenderingExtension.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)
   at bool Telerik.Reporting.Processing.ReportProcessor.RenderCore(ExtensionInfo extensionInfo, IList<Report> processingReports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at bool Telerik.Reporting.Processing.ReportProcessor.ProcessAndRender(string format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at bool Telerik.Reporting.Processing.ReportProcessor.ProcessAndRenderStateless(string format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at RenderingResult Telerik.Reporting.Processing.ReportProcessor.RenderReport(string format, ReportSource reportSource, Hashtable deviceInfo, CancellationToken cancellationToken)+(SingleStreamManager sm) => { }
   at RenderingResult Telerik.Reporting.Processing.ReportProcessor.RenderReportSafe(Func<SingleStreamManager, bool> renderCallback, string format, IRenderingContext renderingContext)
   at RenderingResult Telerik.Reporting.Processing.ReportProcessor.RenderReport(string format, ReportSource reportSource, Hashtable deviceInfo, CancellationToken cancellationToken) x 2
   at void CabMD.TaskRunner.ReportTasks.GeneratedReportTask(Task theTask, PerformContext context) in D:/Projects/CabMD/Source/CabMD.TaskRunner/ReportTasks.cs:line 431

[Dimitar]

Hi Kori,

Thank you for the provided information about the issue!

Considering that the issue occurs after the report grows past a certain size, I believe that this is an issue of the Microsoft Excel 97-2003 (XLS format), which has certain limitations. For example, the maximum number of rows in a worksheet is limited to 65,536. If this is exceeded, the renderer displays an error message. This is elaborated in the Excel 97-2003 section of the Telerik Reporting Rendering and Paging Design Considerations for Report Rendering Excel Rendering - Telerik Reporting article.

However, if you need to export bigger Excel documents, I recommend exporting the report in the newer XLSX format because it supports up to 1 million rows and 16 000 columns.

If you do not see this format among the export options in the dropdown, please take a look at the Telerik Reporting Missing Export Options in Viewers or Rendering Format Not Available - Telerik Reporting article for instructions on how to add the OpenXML formats(DOCX, XLSX, and PPTX).

I hope that the provided information and suggestions will help resolve the issue.

Regards,
Dimitar
Progress Telerik