Program Not Responding 2

[clydejones]

Hi All,

I have a Crystal Report ver 8.0 report attached to a SQL 2000 Server stored procedure. When I try to run the report. It just hangs and I get the "Program Not Responding" message when I close it. I don't even have any fields on the CR form! The stored procedure runs with the SQL Query Analyzer. I must admit it is a huge sproc. Does anyone have any ideas? I'm wide open to suggestions.


Thanks,
Clyde

 

[pgtek]

Hi

check your links in your store procedure
that will cause it to hang

cheers



pgtek

 

[cjlarue]

If the report calculates formulas fields , summaries etc. and is having to process this great amount of data I have seen reports hang for several minutes during this processing. It is also dependent on the resources of the machine where the report is running.


Regards
Chuck LaRue
ADRS Computer Services