Hi-
I have a crystal reports application that processes multiple crystal report objects every day (usually 25-50) and has for the last 5 years. I use CR 11.5 (on Windows XP) but also have the program in CR 2008 (on Windows 7) for overflow processing. They both use a sql server 2008 r2 database.
Anyways, the reports are very complex, and range from 50 to 80 pages of statistical analyses, and may process 1k to 10k rows of data. I have processed up to 150,000 rows of data and it'll take 10-15 hours to do that! The client has now asked us to process 300,000 rows of data and the report does not seem able to and I can't figure out why. It loads all of the records in fine, but at some point in processing, it seems to just stall. I get the message "Crystal reports has stopped working error message" and it happens in CR 11.5, CR 2008 and on both XP and 7 machines (I have tried 32 and 64 bit).
Do you think that Crystal is running out of system resources? Is there some natural limitations to processing a report? I can't tell if this is hardware or CR related. Any suggestions are welcome.
Thank you.
I have a crystal reports application that processes multiple crystal report objects every day (usually 25-50) and has for the last 5 years. I use CR 11.5 (on Windows XP) but also have the program in CR 2008 (on Windows 7) for overflow processing. They both use a sql server 2008 r2 database.
Anyways, the reports are very complex, and range from 50 to 80 pages of statistical analyses, and may process 1k to 10k rows of data. I have processed up to 150,000 rows of data and it'll take 10-15 hours to do that! The client has now asked us to process 300,000 rows of data and the report does not seem able to and I can't figure out why. It loads all of the records in fine, but at some point in processing, it seems to just stall. I get the message "Crystal reports has stopped working error message" and it happens in CR 11.5, CR 2008 and on both XP and 7 machines (I have tried 32 and 64 bit).
Do you think that Crystal is running out of system resources? Is there some natural limitations to processing a report? I can't tell if this is hardware or CR related. Any suggestions are welcome.
Thank you.