Hi, I have a report which has 9 datasets. Due to which it is taking a lot of time to (sometimes even gives the error of "System out of memory"). Is there any way of controlling the execution of datasets, one at a time? OR is there any thing which I can do to make the reports faster. Any help would be much appreciated. Thanks

The number of data sets is not likely a problem - the issue is the number of rows in each and the execution plan to retrieve the data For instance, I have created reports that have 15+ datasets but as each one only retrieves a few rows there is no issue 2 things to look at: 1: Indexes on tables to improve query efficiency 2: Create a dedicated report table in your db that stores all data (or most of it) for this report - ue SQL processing to update this table overnight (or on whatever regularity you need) and point the report at this table instead of multiple datasetsRgds Geoff

Hi Geoff, Thanks a lot for your guidance. You are right, the number of rows returned by each of the datasets are quite large (40K rows.) Indexes are proper, however I have not tried the "dedicated reprot table" as yet. I'll do that. But can you help me in controlling the way the dataset executes i.e. I want only one dataset to be executed at a time. Regards, Rupesh

Hi Rupesh, Every dataset in Reporting Services will run at a same time. It's a default behavior and we cannot change it. But you can try to make some of them return an empty result set with some conditions (depend on your business logic). Regards, Albert Ye