Performance Tuning of Reports

This is again another broad topic, but here are a few useful tips:

•  Optimize your report queries- you can use tools such as query analyzer and sql profiler to optimize your query. Database tuning advisor can suggest better indexes for your database.
• Look at the execution log table, see if you find anything running slow, it will help you determine what you need to optimize.
• Report caching: it allows temporary copies of a report to be stored and rendered to a user.
• Snapshot
• Execution Snapshot: is viewed from a report folder in report manager  just like on-demand reports would be viewed.
• History Snapshot: Creates a  report history and are viewed from the history tab of the report and can accumulate many copies.