§ 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 your queries and Database Tuning
Read More...
