I'm using crystal XI and the crystal ActiveXReportViewer to create anv view reports via Progress.
The reports are fairly simple, without subreports, and workt great locally but when applied to the actual development environment it takes AGES!
A report that takes about 2 secs on my local machine takes about 4 minutes(!!) in the development environment.
The problem is identified to the openreport-method but I can't find anything on the web about performance tuning in this area.
Do you guys know of anything than could cause this or is it simply something you have to live with?
The code is nothing fancy:
DEFINE VARIABLE crApplication AS COM-HANDLE NO-UNDO.
DEFINE VARIABLE crReport AS COM-HANDLE NO-UNDO.
DEFINE VARIABLE crDatabase AS COM-HANDLE NO-UNDO.
CREATE "CrystalRuntime.Application" crApplication.
CREATE "CrystalRuntime.Report" crReport.
/* Set the report object */
crReport = crApplication:OpenReport("c:/temp/lenasreport.rpt").
/* Connect the viewer to the report (with the db connection ) */
chCtrlFrame:CrystalActiveXReportViewer:ReportSource = crReport.
/* View the report */
chCtrlFrame:CrystalActiveXReportViewer:ViewReport().
RELEASE OBJECT crApplication.
RELEASE OBJECT crReport.
The reports are fairly simple, without subreports, and workt great locally but when applied to the actual development environment it takes AGES!
A report that takes about 2 secs on my local machine takes about 4 minutes(!!) in the development environment.
The problem is identified to the openreport-method but I can't find anything on the web about performance tuning in this area.
Do you guys know of anything than could cause this or is it simply something you have to live with?
The code is nothing fancy:
DEFINE VARIABLE crApplication AS COM-HANDLE NO-UNDO.
DEFINE VARIABLE crReport AS COM-HANDLE NO-UNDO.
DEFINE VARIABLE crDatabase AS COM-HANDLE NO-UNDO.
CREATE "CrystalRuntime.Application" crApplication.
CREATE "CrystalRuntime.Report" crReport.
/* Set the report object */
crReport = crApplication:OpenReport("c:/temp/lenasreport.rpt").
/* Connect the viewer to the report (with the db connection ) */
chCtrlFrame:CrystalActiveXReportViewer:ReportSource = crReport.
/* View the report */
chCtrlFrame:CrystalActiveXReportViewer:ViewReport().
RELEASE OBJECT crApplication.
RELEASE OBJECT crReport.