There is a comprehensive round-up of current SQL Server reporting samples from Microsoft available on Codeplex here http://www.codeplex.com/MSFTRSProdSamples. Samples include reports for SQL Server 2005 and SQL Server 2008.

To run the individual reports featured in these samples go to the Report Library page.

The following SQL Server 2005 Report Packs are available for download from Microsoft.com or you can view the individual reports by clicking on the Report Library page.

SQL Server 2005 Integration Services Log Reports

Download this set of reports that are designed to filter, analyze, and organize Log and Error row data generated by SQL Server 2005 Integration Services (SSIS). The reports provide useful views of the SSIS log data saved in a SQL Server database.

SQL Server 2005 Report Pack for Microsoft SharePoint Portal Server 2003

Download this set of eight predefined reports and a sample database to easily visualize and author managed reports such as site trend, storage trend, site collection, and search terms, based on information extracted from a SharePoint Portal Server 2003 environment

SQL Server 2005 Report Pack for Microsoft Dynamics Axapta 3.0

Download this set of six predefined Axapta 3.0 reports and a sample database. These sample reports include purchase order, sales order, rolling invoice, CRM recap, and order delivery performance. With some minor changes, this report pack can also work against an existing Microsoft Dynamics Axapta 3.0 environment

SQL Server 2005 Report Pack for Microsoft Dynamics Navision 4.0

Download this set of 22 predefined Navision 4.0 reports. These sample reports include customer profitability, regional sales, inventory turnover, and budget analysis. With some minor changes, this report pack can also work against an existing Microsoft Dynamics Navision 4.0 environment.

SQL Server 2005 Report Pack for Microsoft Dynamics Great Plains 8.0

Download this set of eight predefined reports that work with Fabrikam, the Microsoft Dynamics Great Plains sample database. The sample reports include inventory value, item back order, sales commissions, purchase order, and sales order. With some minor changes, this report pack can also work against an existing Microsoft Dynamics Great Plains 8.0 environment

SQL Server 2005 Report Pack for Microsoft Dynamics Great Plains 9.0

Download this set of eight predefined reports that work with Fabrikam, the Microsoft Dynamics Great Plains sample database. The sample reports include inventory value, item back order, sales commissions, purchase order, and sales order. With some minor changes, this report pack can also work against an existing Microsoft Dynamics Great Plains 9.0 environment

SQL Server 2005 Report Pack for Microsoft Internet Information Services (IIS)

Download this set of 12 predefined reports and a sample database to easily visualize and author managed reports such as site summary statistics, time period, page views and user statistics, based on information extracted from IIS log files.

SQL Server 2005 Report Pack for Financial Reporting

Download this set of six predefined financial reports and a sample database to easily visualize and author managed reports to support key finance activities