cheskey1977
MIS
Hello All,
We are running into some Crystal Reports that run in the ballpark of 1+ hours. I was wondering if there are problems with Crystal Reports (version 6) handling (read: returning and running calculations on) large amounts of data.
We are using-
DB: Oracle 8i (on a Sun/Unix platform with 16X400 proc, 16384 RAM)
ERP: PeopleSoft 7.5 (App/Server on same UNIX machine)
Reporting: Crystal 6, and some queries may return upwards of 80,000 rows to use in calculations
Client OS: Windows 95 (I know, I know...)
In testing we are opening the Crystal reports on the Client Window, and they can take up to an hour or hang.
Any advice or personal experiences with long running reports would be greatly appreciated.
Cheers.
We are running into some Crystal Reports that run in the ballpark of 1+ hours. I was wondering if there are problems with Crystal Reports (version 6) handling (read: returning and running calculations on) large amounts of data.
We are using-
DB: Oracle 8i (on a Sun/Unix platform with 16X400 proc, 16384 RAM)
ERP: PeopleSoft 7.5 (App/Server on same UNIX machine)
Reporting: Crystal 6, and some queries may return upwards of 80,000 rows to use in calculations
Client OS: Windows 95 (I know, I know...)
In testing we are opening the Crystal reports on the Client Window, and they can take up to an hour or hang.
Any advice or personal experiences with long running reports would be greatly appreciated.
Cheers.