Issues with Crosstab exports from web viewer

[Jim]

I'm having issues when exporting a report with a Crosstab from the web viewer.  The report works as I expected in the web viewer.

For most export types (except web archive), the far right "total" column is just missing.

For Excel exports I get an exception:

Server Error in '/' Application.

---

Attempting to get range {2,5}{1,1},Merged=False,Parent=Session Scoring[0], that intersects with an already merged range.

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.InvalidOperationException: Attempting to get range {2,5}{1,1},Merged=False,Parent=Session Scoring[0], that intersects with an already merged range.

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:

[InvalidOperationException: Attempting to get range {2,5}{1,1},Merged=False,Parent=Session Scoring[0], that intersects with an already merged range.] Telerik.Reporting.Excel97.Worksheet.GetRange(Int32 col, Int32 row, Int32 colSpan, Int32 rowSpan) +207 Telerik.Reporting.ExcelRendering.Excel97.Worksheet.Telerik.Reporting.ExcelRendering.IWorksheet.GetRange(Int32 col, Int32 row, Int32 colSpan, Int32 rowSpan) +91 Telerik.Reporting.ExcelRendering.RenderingItem.GetRange(IWorksheet worksheet, TableLayoutInfo layoutInfo) +467 Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +80 Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +170 Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +259 Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +170 Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +259 Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +170 Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +259 Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +170 Telerik.Reporting.ExcelRendering.Section.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +76 Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +259 Telerik.Reporting.ExcelRendering.Group.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +136 Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +259 Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +170 Telerik.Reporting.ExcelRendering.Report.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo) +837 Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo) +259 Telerik.Reporting.ExcelRendering.Report.Render(IWorkbook workbook) +443 Telerik.Reporting.ExcelRendering.Excel97.ExcelReport.Telerik.Reporting.Processing.IRenderingExtension.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback) +187 Telerik.Reporting.Processing.ReportProcessor.Render(IList`1 reports, ExtensionInfo extensionInfo, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback) +1349 Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, IReportDocument reportDocument, Hashtable deviceInfo, Hashtable renderingContext, CreateStream createStreamCallback) +587 Telerik.ReportViewer.WebForms.ServerReport.Render(HttpResponse response, String format, Int32 pageIndex) +849 Telerik.ReportViewer.WebForms.ReportExportOperation.PerformOperation(NameValueCollection urlQuery, HttpContext context) +135 Telerik.ReportViewer.WebForms.HttpHandler.ProcessRequest(HttpContext context) +368 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +867 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +120

---

Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4927


This happens with Q2 2010 Internal Build v4.1.10.729 which I'm using because it fixes another issue I was having.

[Steve]

Hi Jim,

There were similar issues that were fixed in the latest internal build, but since you state that the problem occurs namely with it, we would appreciate if you open a support ticket and attach a sample runnable report so we can debug what is happening locally.

Kind regards,
Steve
the Telerik team

[Jim]

done, #340796

[Pierre-Alain]

Any update on this?

I made sure that I had no overlapping items and when I try to export to XLS, it gives me a similar error.

[Jim]

It's no longer an issue for me, support suggested:

We are able to narrow down the behavior you have experienced to the nested Table/Crosstab/List items. Thus our suggestion is to avoid nesting Table/Crosstab/List items when possible and instead of the List to use the Report itself for the Crosstab container. However we will have your case in mind when we make further improvements of the Table item in subsequent versions of Telerik Reporting.

so in my case the report needed reworking with the crosstab being moved from the detail section into a group header section to get the breaking/grouping behavior I was looking for.