Professional SQL Server 2008 Reporting Services
Sample reports and Visual Studio projects

Visual Studio & Programming Samples:

If you have any version of Visual Studio 2008 installed, you can open the 'Pro SQL Svr 2008 Reporting Svcs' Visual Studio solution, which contains the sample projects for all related chapters. The programming-related projects require Visual Studio.

If you have only Business Intelligence Development Studio installed or have not installed both Visual Basic and C# language support, you may remove the unsupported projects from the solution to avoid errors.  These projects can be added later or opened seperately if you decide to install the required Visual Studio components.

Sample Databases:

The following sample databases are used in reports and may be downloaded from www.codeplex.com (maintained by Microsoft):
AdventureWorks2008	Relational
AdventureWorksDW2008	Relational
Adventure Works DW SE	OLAP

Analysis Services Sample Report Database Name:

There are a few different variants of the AdventureWorks DW sample database for Analysis Services.
If you have installed a different version than "AdventureWorks DW SE", as used in the sample reports, you may change the database name in the AdventureWorksDW2008_AS shared data source for this project to the database you have installed - or download and install the AdventureWorks DW SE database from www.codeplex.com.

Report Catalog & Report Execution Log Sample Reports:

These two reports use the Reporting Services catalog database for the data source.  Since this database can be given any name during the RS installation, you may need to change the database name in the embedded data sources.  The default database name is ReportServer.  These reports are designed to work in Native mode but can be modified to work in SharePoint Integrated mode.  For the Execution Log report to be effective, it must run on an active report server with significant report execution history.  If this is not the case, PDF copies of these reports are provided for example purposes.