Please share the best practices tips that you follow when creating reports using SSRS. Suresh My Scribbling

http://www.sqlserverbiblog.com/CategoryView,category,SSRSDesign.aspx http://206.72.113.13/BlogEngine/page/Paperback-Writer.aspx Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com *Please vote if helpful*

Hi, The above links mentioned by Paul are very good to start with. I just got two major points to add to it. Hope it helps :) Optimize SQL Reporting Services Queries Optimize your report queries. Usually, the bulk of report execution time is spent executing queries and retrieving results. If you are using SQL Server, tools such as Query Analyzer and Profiler can help you optimize queries. Report Subscription Scheduling Whenever possible, schedule report subscription processing to run outside of normal office hours. This will reduce load on the reporting server and improve availability for ad hoc report requests. Regards, PS Regards, PS