Skip to Content
0
Former Member
Jan 13, 2010 at 04:51 PM

Extremely Slow Report Performance

23 Views

I have a report that I have been using for several years with no problems until recently. I made a change to the stored procedure that the report uses, and now the report will take several hours to run; whereas previously it took less than a minute. The change to the proc was very minor and involved only changing some verbage on a static text field that the procedure returned. The output of the procedure was not changed, and I can run the procedure using SQL management studio in less than 2 seconds. However, as I said Crystal Report takes several hours to run this same stored procedure. I even tried creating a brand new report and using this procedure as the datasource, and it did the same thing. This makes absolutely no sense to me. Can anyone tell me why this is happening? I'm using Crystal Reports 2008 with sp2.