TOPIC: Report Takes a LONG Time to Run

Report Takes a LONG Time to Run 28 Feb 2014 17:03 #1529

  • mchavez22
  • mchavez22's Avatar
  • Offline
I have a report that takes about 2 minutes to run in Crystal Reports, but in Logicity Crystal Report Viewer it takes an hour to run. Has anyone seen this before? Do you know why this would happen or what I could do to reduce the run time? Thanks!
The administrator has disabled public write access.

Report Takes a LONG Time to Run 03 Mar 2014 14:23 #1530

  • AWhewell1984
  • AWhewell1984's Avatar
  • Offline
Are you running the report on the same machine? If not, potentially the database drivers are not the same and so it causes a slowdown. I've had that myself with our Progress database and found moving from Merant to Data Direct did wonders.

After that, I would assume it's something to do with the way the database query is being read or the connection priority. I can't answer for that bit though as it will be how Logicity is picking up the settings from the rpt file.

Thanks,

Andrew
The administrator has disabled public write access.