Hi, I am beginner in SSRS.I have developed two reports .I have 4 filters in one report and 7 filters in other report.The execution time for each report is around 4-7 min. Can anyone pls guide me in providing some tips to reduce the execution time?? Thanks in Advance Regards, Swathi.CRegards, Swathi

Hi Swathi, Thanks for your question here. Actually, if we use filter in the report, the results being queried from database engine, then filtered in the report side. For complex filters, the report engine need to analysis them then filtered the results again. In addition, the report server has powerful application on report management, for the query performance, the database engine is better than the report engine. Based on previous analysis, if it is possible and you have the permission to edit the T-SQL query of the dataset, I would recommend you filter the results in database engine side. In order to improve the performance of the Transact-SQL, please reference below two articles: Transact-SQL Optimization Tips Transact-SQL Performance Tips Hope them help you. If there is anything unclear, please feel free to ask. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

http://msdn.microsoft.com/en-us/library/bb522786.aspx. has some concepts with respect to performance improvemnet in SSRS 2008R2.Happy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!