Reporting Services Tutorials (SSRS)
Updated: August 26, 2016
Applies To: SQL Server 2016
This section contains tutorials for SQL Server 2016 Reporting Services (SSRS).
Create a Basic Table Report (SSRS Tutorial)
Follow the steps in this tutorial to learn how to create your first report. This tutorial shows you how to work with SQL Server Data Tools (SSDT) to create a data connection (data source), define a simple query (dataset), and configure a data region to contain your data.
Create a Data-Driven Subscription (SSRS Tutorial)
Reporting Services provides data-driven subscriptions so that you can customize the distribution of a report based on dynamic list of subscribers that will receive the report. Data-driven subscriptions are typically created and maintained by report server administrators. The ability to create data-driven subscriptions requires expertise in building queries, knowledge of data sources that contain subscriber data, and elevated permissions on a report server.
Create a Drillthrough (RDLC) Report with Parameters using ReportViewer (SSRS Tutorial)
Follow the steps in this tutorial to learn how to create a drillthrough report with parameters and a filter using the ReportViewer control.
Report Builder Tutorials
Tutorials to help you use Report Builder create rich reports that contain data visualizations such as Maps and Sparklines as well as tutorials on how to use parameters and expressions.
Adventure Works 2014 Sample Databases
Adventure Works 2012 Sample Databases
Reporting Services Samples on CodePlex (http://go.microsoft.com/fwlink/?LinkId=198283)
TechNet WIKI: SQL Server 2012 Samples (http://go.microsoft.com/fwlink/?linkID=220734)
Picnic Dataset (Sample Data) (http://go.microsoft.com/fwlink/?linkID=219108)