SQL Server Samples Portal Page > SQL Server Reporting Services Product Samples

SQL Server Reporting Services is a comprehensive, server-based solution that enables the creation, management, and delivery of both traditional, paper-oriented reports and interactive, Web-based reports. An integrated part of the Microsoft business intelligence framework, Reporting Services combines the data management capabilities of SQL Server and Microsoft Windows Server with familiar and powerful Microsoft Office System applications to deliver real-time information to support daily operations and drive decisions.
For Reporting Services and Report Builder resources, click here.

This project contains Reporting Services samples released with Microsoft SQL Server product. These samples are in the following five categories: Application Samples, Extension Samples, Model Samples, Report Samples, and Script Samples. If you are interested in contributing Reporting Services samples, please let us know by posting in the developers' forum.
Note:
On August 22th, SQL Server 2008 RS SR1 was released. It includes additional Reporting Services samples. Most of the programming samples, not included in the earlier release of SQL Server 2008 R2 Reporting Services samples, are now available and included in the downloads.

The added extension samples are:
  • Custom Report Item (Polygon report item)
  • Security Extension Sample (Forms authentication)
  • Active Directory
The added application samples are:
  • AsynchronousRender
  • FindRenderSave
  • ReportSearch
  • RSExplorer
  • RSPermissions
Download Samples and Databases
To download the samples click on the DOWNLOADS tab (or click here), optionally select another (older) release, then click on the Windows Installer package (MSI file) which matches the architecture of the installation computer. By default, the SQL Server 2008 R2 Reporting Services download is the x64 MSI. Click on the DOWNLOADS tab to see a list of all available versions (x64 MSI, x32 MSI, and ZIP file) and download the version you want.

The SQL2008R2.ReportingServices.Samples.zip file contains only the Application Samples and Extension Samples. The SQL2012.ReportingServices.AdventureWorks2012.zip file contains the AdventureWorks Sample Reports for SQL Server 2012. The Drillthrough Report Sample.zip file contains the Drillthrough Report Sample for SQL Server 2012.

For information about how to use CodePlex to access SQL Server samples, click here.

To download samples databases, click here and then click the appropriate MSI file.
For release notes and brief descriptions of all the sample databases and code, including restrictions on SQL Express and Vista, click here.

Report Samples

Sample SQL Server 2005 SQL Server 2008 SQL Server 2008R2 SQL Server 2012
AdventureWorks Sample Reports SS2005 SS2008 SS2008R2 SS2012
AdventureWorksOffline Report Samples n/a SS2008 SS2008R2 n/a
Report Builder Report Samples SS2005 SS2008 n/a n/a
Report Builder 3.0 Stand-alone Report Samples n/a n/a SS2008R2 n/a
Server Management Sample Reports SS2005 SS2008 n/a n/a
Drillthrough Report Sample n/a n/a n/a SS2012

Model Samples

Sample SQL Server 2005 SQL Server 2008 SQL Server 2008R2 SQL Server 2012
AdventureWorks Sample Model SS2005 SS2008 SS2008R2 n/a

Application Samples

Sample SQL Server 2005 SQL Server 2008 SQL Server 2008R2
AsynchronousRender Sample Windows Application SS2005 SS2008 SS2008R2
FindRenderSave Sample Windows Application SS2005 SS2008 SS2008R2
ReportSearch SS2005 SS2008 SS2008R2
RSExplorer Sample Application SS2005 SS2008 SS2008R2
RSPermissions Sample Application n/a SS2008 SS2008R2


Extension Samples

Sample SQL Server 2005 SQL Server 2008 SQL Server 2008R2 SQL Server 2012
Custom Report Item Sample SS2005 SS2008 SS2008R2
File Share Data Processing Extension Sample SS2005 SS2008 n/a
Printer Delivery Extension Sample SS2005 SS2008 n/a
Active Directory Extension Sample n/a SS2008 SS2008R2
Security Extension Sample SS2005 SS2008 SS2008R2 SS2012



Script Samples

Sample SQL Server 2005 SQL Server 2008 SQL Server 2008R2
Script Samples (Reporting Services) SS2005 SS2008 n/a



Got questions? Want to contribute? Check out the SQL Server Community & Samples Discussion Forum!

Last edited Aug 25, 2013 at 6:46 AM by sabottaca, version 54