dragonlair
Programmer
I am running a report via asp which has an exceptionally large number of running totals. Add to this a stored procedure that can bring back as many as 1.5 million records. The report will can take as long as 24+ hours to run. The problem is that I have not been able to test this out. I have set the Server.ScriptTimeOut in the asp for 100,000 seconds, and the timeout in the VB dll file for the ODBC for about 15 minutes. When I run a test report that brings up a large number of records, as soon as the report has run for 1 hour, the Crystal Report Viewer pop up comes up with an unreadable message and the report freezes. Is there another timeout for the activex smartviewer or something else that I am missing that is interfering with the report generating the totals as it is supposed to? I do not have this problem when running the report in the Report builder, just when generation in an asp page through a viewer.
Thanks in advance for any help you can provide.
Bob
Thanks in advance for any help you can provide.
Bob