[From SQLServer Performance
SQL Server Reporting Services (SSRS) in SQL Server 2005 has given users many options to on how to create a report. This article describes several methods that can be used to develop the same report. In addition, we will analyse the performance of each method so that we know the pros and cons of each option. Whenever we have the option of selecting a method we need to ensure that we select the right one.
The article continues at