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 resources, click here. For Report Builder specific 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 download packages.

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

To download these samples click on the Releases 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 View all downloads to see a list of all available versions (x64 MSI, x32 MSI, and ZIP file) and download the version you want.t

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
AdventureWorks Sample Reports SS2005 SS2008 SS2008R2
AdventureWorksOffline Report Samples n/a SS2008 SS2008R2
Report Builder Report Samples SS2005 SS2008 n/a
Report Builder 3.0 Stand-alone Report Samples n/a n/a SS2008R2
Server Management Sample Reports SS2005 SS2008 n/a

Model Samples

Sample SQL Server 2005 SQL Server 2008 SQL Server 2008R2
AdventureWorks Sample Model SS2005 SS2008 SS2008R2

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
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




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 Sep 13, 2011 at 9:31 PM by mariwill, version 40