Report Builder tutorials

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

Use the following Report Builder tutorials to learn how to create basic Reporting Services paginated reports.

Prerequisites for tutorials (Report Builder)
To use these tutorials, you must have read-only access to a SQL Server database and permissions to access a SQL Server 2016 (13.x) Reporting Services or later (SSRS) report server.

For help with these prerequisites, contact your report server administrator.

Alternative ways to get a data connection (Report Builder)
Most of these tutorials use embedded data sources. If you have access to shared data sources, you can use them instead. This article provides the steps for using shared data sources.

Tutorial: Create a basic table report (Report Builder)
Follow the steps in this tutorial to learn how to create your first report. This tutorial shows you how to work with Report Builder to create a data source connection, define a query, build a layout to contain your data, format your report, and add grouping and totals.

Tutorial: Create a matrix report (Report Builder)
Follow the steps in this tutorial to learn how to add and configure a matrix. You use the Table or Matrix Wizard to create the report data source, dataset, and layout, and then enhance the matrix within the Design view of Report Builder.

Tutorial: Create a free form report (Report Builder)
Follow the steps in this tutorial to learn how to create a free-form report from scratch. This report resembles a newsletter.

Tutorial: Format text (Report Builder)
Follow the steps in this tutorial to learn some of the many ways you can format text in your reports.

Tutorial: Add a column chart to your report (Report Builder)
Follow the steps in this tutorial to learn how to add a column chart with a moving average to a report.

Tutorial: Add a pie chart to your report (Report Builder)
Follow the steps in this tutorial to learn how to add a pie chart to a report.

Tutorial: Add a bar chart to your report (Report Builder)
Follow the steps in this tutorial to learn how to add a bar chart to a report.

Tutorial: Add a sparkline to your report (Report Builder)
Follow the steps in this tutorial to learn how to create a matrix and then add a set of sparkline charts to the matrix.

Tutorial: Add a KPI to your report (Report Builder)
Follow the steps in this tutorial to learn how to add a key performance indicator (KPI) to a report.

Tutorial: Map report (Report Builder)
Follow the steps in this tutorial to learn how to add a map to a report.

Tutorial: Add a parameter to your report (Report Builder)
Follow the steps in this tutorial to learn how to customize the appearance and content of a report by using parameters.

Tutorial: Create drillthrough and main reports (Report Builder)
Follow the steps in this tutorial to learn how to create reports for a drillthrough scenario based on an Analysis Services cube. You create the main report and enable it for drillthrough and the report that is the target of the drillthrough action.

Tutorial: Introduce expressions
Follow the steps in this tutorial to learn how to use expressions to concatenate, calculate, and look up field values and show them a report. You also learn how to conditionally display different images and indicator states using expressions.

More questions? Try asking the Reporting Services forum.