I did a simple select below on a DB table that has a total of around 650,000 records. If I run this select in Query Analyzer, it takes around 11 seconds and returns 19,000 records.
In my SSRS report, I've created a dataset that runs this query, the same one I ran in Query Analyzer that took only 11 seconds:
select * from master where customer = '0000002'
After putting this select in a dataset, I then grabbed one of the fields and threw it into a table's Detail row. It took forever, about 10 minutes!
granted the user who tried this is using a very inefficient Select * , but even so, it shouldn't take this long to preview and it froze my PC! The server that's running SSRS has 2 gb memory, around a 3.8 ghz processor, etc. The server that it's fetching the records from is about the same config.
I supposed I can try this in a stored proc in my dataset but the performance shouldn't improve by 30 minutes.
We a ran the same query, same setup in Crystal and it only took seconds!
SSRS taking forever to load a simple select
supergatito123
Your delay is most likely caused by the processing of the dataset by Reporting Services, not the execution of the query. We are looking at ways to improve RS for future versions and this is one of those items.
Improving the dataset that is returned by your query will help significantly in your case.
nery_jose