Reporting Services Tutorials (SSRS)

Applies to: SQL Server 2016 (13.x) Power BI Report Server

Explore the capabilities of SQL Server 2016 Reporting Services or later (SSRS), SQL Server Data Tools (SSDT), and Report Builder with sample data in these tutorials.

Create a Basic Table Report

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

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

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

These tutorials introduce you a variety of visualizations you can create in Report Builder, such as maps and sparklines, as well as tutorials on how to use parameters and expressions.

See Also