Crystal Reports XI - report.ExportToDisk(Excel, reportName) sluggish C#
I am generating Excel/PDF reports using a report created in Crystal Reports XI.
PDF generation would usually take a few seconds but Excel generation usually takes 50-60 minutes.
Underlying DB is SQL Server 2000 and report has 2 subreports.
Data is retrieved from report itself and credentials are set using TableLogOnInfo. This TableLogOninfo is applied on each table within report.
To generate the report I am using ReportDocument.ExportToDisk(exportFomat, Filename) in C#.
Issue is why is Excel report taking so long to generate while pdf is fairly faster. Is there any optimisation that can be carried out while generating the report, perhaps a different method for Excel rendering?
Are there any known issues while generating Excel report from Crystal Reports?