Report much slower than query (Crystal Reports 9)

[maxl26]

Hi everyone. I've created a stored procedure for a report in MS-SQL. In the query analyzer this proc runs in about 10 seconds. When I put it in my report, it takes forvever to access the database and also a lot of time to read the records. I've updated my Crystal Reports without success. Has anybody ever faced a similar problem ?? Any help would be greatly appreciated.

 

[synapsevampire]

I would guess that you're using a slower connectivity, are you using OLE DB, ODBC or Native?

Native is generally the fastest, test.

-k

 

[maxl26]

I'm using Ole DB, but I've solved the problem, by clearing everything in the report and starting all over again, seem to work for now. Thanks for your input, i'm gonna look into it anyway.