views:

820

answers:

3

I have a problem with Crystal Reports 8. When exporting a report from my application, Crystal Reports sometimes freezes. The progress windows just stays, saying X of X records exported.

  1. Smaller reports with less data are more likley to freeze.
  2. Faster workstations (P4, Core2) tend to freeze much more often, sometimes every second try. On older workstations (< P2) no freezing happens at all, or at least once every one or two days.
  3. The export format (rtf, pdf, html, rpt) does not influence the freezing behavior.
  4. The same report can be successfully exported multiple times with excactly the same data, but eventually it will freeze.
  5. No freezing happens on Windows Vista (!)

Is there a way to stop this or at least a way to predict a freeze?

+1  A: 

CR 8 is a fairly old product, you may want to check whomever owns it now (Business Objects still?) for updates (hotfixes for v8 specifically). This could be something they've fixed in the past with a service release.

Jeff Schumacher
Yes, we've done that (CR 11). But unfortunatly we have to provide support for some of our legacy products.
DR
Sorry, I should clarify. I did not mean upgrade to the latest version, I meant updates in the way of hotfixes to v8 of the product.
Jeff Schumacher
Ok, sorry, I should have read more carefully... We've tried that already, with no success.
DR
+1  A: 

After a long search we finally tracked down the source to a WaitForSingleObject(?, INFINITE) call. It seems like CR8 has some synchronization errors which become obvious on fast workstations.

It is somehow related to the progress window, and the animations in Vista seem to mitigate the problem.

Theoretically the solution would be patching the problematic file and replacing the WaitForSingleObject with a timeout parameter.

DR
Might I ask how you identified this as the cause of the problem? I'm experiencing a similar problem during a mass export of thousands of CR8.5 files.
CodeByMoonlight
I used ProcessMonitor do display the callstack of each thread.
DR
A: 

So having tracked down the possible origin of your problems, how did you finally solve the issue? I have to deal with the same subject (crystal reports 8 freezing on fast machines).