Crystal Reports 10 Keeps Locking Out When Reporting From A Stored Procedure
Posted on 2005-04-30
I am having problems with one of the reports I have developed, it runs off a stored procedure, thats pretty similar to many others I have developed. When I refresh the two parameters @startdate and @enddate, both reporting off a smalldatetime field, the report runs for a while, freezes Crystal , then comes back with the following error. I get the following error about every 9 times out of 10 I run this report
Transaction deadlock victim, error 4001, failed to open a rowset.
I have broken the stored procedure down into parts but still it keeps freezing Crystal. Of course its one of the most important reports that is run and my bosses are screaming blue murder
I have looked at indexes and datatypes to make sure everyting is okay,which it is. On the odd occasion that the report runs it takes at least 5 minutes. The report returns about 30 - 40 records when run.
Does anyone know why it keeps on doing this.