Error trying to Export

Aspose.Cells Product Family
1

I get the following error when trying to export my report to excel workbook via aspose.cells:

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[Exception: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index]

[Exception: An error occurred during rendering of the report.]


[Exception: An unexpected error occurred in Report Processing.]

Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +495

Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +958

Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84

Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +143

Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +110

System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +303

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64


Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

My report is a table with subreports and the subreports all have graphs. Any ideas would be appreciated.

Thanks.

-Scott.J

2

Hi,

Thanks for considering Aspose.

Are you using Aspose.Cells.ReportingServices and which version you are utilizing to render the excel report. If, so, could you post your .rdl file here to show the issue. We will check and fix it soon.

Thank you.

3

Thank you for the reply (sorry I have been out of the office). I am using the Aspose.Cells.ReportingServices.dll version 1.0.2.2 - I think that is the latest.

I have attached our RDL. We have a somewhat dynamic result set coming back from SQL so what we do is have a table with subreports. We have three different subreports right now and the report determines which one to show (for each row of the table) based on data coming back.

Here is the main RDL. I will reply 3 more times with the three subreports.

Thank you!

SJ

4

Hi,

Thanks for .rdl files, We will check and figure out your issue soon.

Thank you.