Reporting Services tutorials (SSRS)

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

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

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). It also shows you how to define a 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 a dynamic list of subscribers that receives the report. Report server administrators typically create and maintain data-driven subscriptions. 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 drillthrough (RDLC) report with parameters - 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 to various visualizations that you can create in Report Builder, such as maps and sparklines. They also show you how to use parameters and expressions.