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

Export to excel timeout

5 Answers 417 Views

General Discussions

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

5 Answers, 1 is accepted

answered on 29 Mar 2011, 08:07 AM

Hi,
I am using Telerik Reporting 2010 Q1. When we export to excel, the application times out immediately. But this is not the case when we export to pdf.
Following is our code:

   private void ExportToExcel()
        {
            try
            {
                DataTable dtSpecialReport = ConstructSpecialReport();

                Telerik.Reporting.ReportBook rptBook = new Telerik.Reporting.ReportBook();
                DataSet dsSessionComparisonReportChartTable1 = SplitDecimalData((DataSet)Session["SessionComparisonReportChartTable"]);
                dsSessionComparisonReportChartTable1 = RemoveDecimalData((DataSet)Session["SessionComparisonReportChartTable"]);

                RptComparisonVehicleReportExport objRptComparisonVehicleReportExport = new RptComparisonVehicleReportExport((DataSet)Session["SessionComparisonReportChartTable"]);
                List<CustomizeCoreAssumptionsBus.CoreAssumption> objRptBus = CustomizeCoreAssumptionsBus.CoreAssumption.GetFields(SessionCRList, SessionCRList[0].OnlineUser.CurrentDatabase.DataBaseName);
                RptComparisonVehicleReportExportVCA objRptComparisonVehicleReportExportVCA = new RptComparisonVehicleReportExportVCA(objRptBus, SessionCRList[0].OnlineUser.FullName.Trim().ToString());

                rptBook.Reports.Add(objRptComparisonVehicleReportExport);
                rptBook.Reports.Add(objRptComparisonVehicleReportExportVCA);
                objRptComparisonVehicleReportExport.Name = "Report";
                objRptComparisonVehicleReportExportVCA.Name = String.Format("CoreAssumptions Vehicle 1 - {0}", SessionCRList.Count);

                if (SessionCRList.Count > 4)
                {
                    RptComparisonVehicleReportExportVCA2 objRptComparisonVehicleReportExportVCA2 = new RptComparisonVehicleReportExportVCA2(objRptBus, SessionCRList[0].OnlineUser.FullName.Trim().ToString());
                    rptBook.Reports.Add(objRptComparisonVehicleReportExportVCA2);
                    objRptComparisonVehicleReportExportVCA2.Name = String.Format("CoreAssumptions Vehicle 5 - {0}", SessionCRList.Count);
                    objRptComparisonVehicleReportExportVCA.Name = "CoreAssumptions Vehicle 1 - 4";
                }

                RptComparisonVehicleReportExportExpander objRptComparisonVehicleReportExportExpander = new RptComparisonVehicleReportExportExpander(dtSpecialReport, SessionCRList.Count);
                rptBook.Reports.Add(objRptComparisonVehicleReportExportExpander);
                objRptComparisonVehicleReportExportExpander.Name = "Special Report";

                rptBook.DocumentName = "ComparisonReport" + DateTime.Now.ToString().Replace(" ", "").Replace("/", "").Replace(":", "");
                rptComparisonViewerExport.Report = rptBook;

                Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
                Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("XLS", rptBook, null);

                Response.Clear();
                Response.ContentType = result.MimeType;
                Response.Cache.SetCacheability(HttpCacheability.Private);
                Response.Expires = -1;
                Response.Buffer = true;

                Response.AddHeader("Content-Disposition", string.Format("{0};FileName=\"{1}\"",
                                    "attachment", result.DocumentName + ".xls"));
                //Response.BinaryWrite(bytes);
                Response.BinaryWrite(result.DocumentBytes);
                Response.End();
            }
            catch (Exception ex)
            {
                ApplicationExceptionHandler(ex, this);
            }
        }

Thanks
Badri