Hi I have a problem. I created a reprt with 6 parameters. I am populating dropdown list for those parameters(using shared data sets). reporting running slow . In perticular it is slow at producing the drop down list and accepting parameters. But any way its running. When I run same report on report manager , it is not working. the explorer is not responding after I select one parameter. Please let me know if u have any sugg to improve the performance?

Hi SQL227, In general, report processing time can be affected by report layout, paging, and complex expressions in areas of a report that have many instances. According to your description, I suspect the report run slow is caused by long time to retrieve data. As we know that sort and aggregation is more efficient on the data source than during report processing. Write queries to return only the level of detail that you show in the report. The following list suggests ideas for evaluating each report query in the report. Please refer to the respects, and to check if those could help you to improve your report performance. 1. Write queries with WHERE clauses or HAVING clauses those limit the data to just what the user must see in the report. Use query parameters to restrict data that is retrieved at run time. 2. Write queries with the ORDER BY clause to presort data that is retrieved for a report. Presorted data improves report processing time because of the way it is stored in memory. If you do not need sorted data in the report, do not set sort expressions on the dataset or data region. 3. Write queries with GROUP BY to aggregate values on the data source. You can calculate some level of aggregates on the data source and retrieve them for a dataset. Otherwise, we suggest you to consider creating execution snapshots for a report. A report snapshot includes all report data retrieved for the datasets in the report definition. For more information, see Creating, Modifying, and Deleting Snapshots in Report History. If the issue still exists, could you please check TimeDataRetrieval, TimeProcessing and TimeRendering in dbo.ExecutionLog2 table on reportserver, and to look for which spent the most time. And then, we could help you better. For more information about the topic, please see the following articles, Troubleshooting Reports: Report Performance: http://msdn.microsoft.com/en-us/library/bb522806.aspx ExecutionLog2 View - Analyzing and Optimizing Reports: http://blogs.msdn.com/b/robertbruckner/archive/2009/01/05/executionlog2-view.aspx If you have any questions, please feel free to ask. Thanks. Eileen