Skip to Content
0
Former Member
Jun 09, 2011 at 08:53 AM

Crystal Reports XI - report.ExportToDisk(Excel, reportName) sluggish C#

137 Views

Hi,

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?

Thanks