Crystal reports load times
Posted on 2012-04-13
This is my last attempt before I ditch Crystal Reports altogether...
I've read lots of articles on speeding up load times of cr's which has become a major issue for me recently, so I redesigned my application into two parts because it's not an app that ever 'stays running' so I couldn't just preload a report at startup.
All my app does now is call a WCF windows service (on the same machine) which stays running and does all the processing, this way I can preload a report at startup so that in theory every load after that should be quick.
Unfortunatlely for me this isn't the case, the results I've seen is that I send a request to process a report and it takes just over a minute to process, if I send another request for the same report it takes a couple of seconds (great :) ) problem is I tell it to process a different report and it takes over a minute again!! There are close to 200 different reports it could be loading so it looks like the re-design is a failure after all.
Has anybody come across this before? Does anybody have any suggestions for me or should I just start looking into a different reporting solution other than CR?