Skip to content

Latest commit

 

History

History
79 lines (58 loc) · 5.59 KB

File metadata and controls

79 lines (58 loc) · 5.59 KB
title Report Builder Tutorials | Microsoft Docs
ms.custom
ms.date 05/30/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
reporting-services-native
ms.tgt_pltfrm
ms.topic get-started-article
applies_to
SQL Server 2016
ms.assetid c99495c3-899b-4c84-af87-76e96d4afa23
caps.latest.revision 11
author maggiesMSFT
ms.author maggies
manager erikre

Report Builder Tutorials

[!INCLUDEssrs-appliesto-sql2016-preview]

Use the following Report Builder tutorials to learn how to create basic [!INCLUDEssRSnoversion_md] 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 [!INCLUDEssRSCurrent] 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 topic provides the steps for using shared data sources.

Tutorial: Creating 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 simple query, build a layout to contain your data, format your report, and add grouping and totals.

Tutorial: Creating a Matrix Report (Report Builder)
Follow the steps in this tutorial to learn how to add and configure a matrix. You will 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: Creating 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: Adding 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: Creating 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 will create the main report and enable it for drillthrough and the report that is the target of the drillthrough action.

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

Next steps

Report Design View
Report Builder in SQL Server 2016
Tutorial: Create a Quick Chart Report Offline

More questions? Try asking the Reporting Services forum