This is a migrated thread and some comments may be shown as answers.

Issues with Crosstab exports from web viewer

4 Answers 80 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Jim
Top achievements
Rank 1
Jim asked on 16 Aug 2010, 08:03 PM
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.

4 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 19 Aug 2010, 12:58 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Jim
Top achievements
Rank 1
answered on 20 Aug 2010, 04:16 PM
done, #340796
0
Pierre-Alain
Top achievements
Rank 1
answered on 08 Oct 2010, 04:26 AM
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.
0
Jim
Top achievements
Rank 1
answered on 08 Oct 2010, 02:06 PM
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.
Tags
General Discussions
Asked by
Jim
Top achievements
Rank 1
Answers by
Steve
Telerik team
Jim
Top achievements
Rank 1
Pierre-Alain
Top achievements
Rank 1
Share this question
or