Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question