title

Create a basic table report (SSRS tutorial)

description

Use the Report Designer tool in Visual Studio / SQL Server Data Tools (SSDT) and then create a SQL Server Reporting Services (SSRS) paginated report.

author

maggiesMSFT

ms.author

maggies

ms.date

04/16/2019

ms.service

reporting-services

ms.subservice

reporting-services

ms.topic

conceptual

ms.custom

updatefrequency5

helpviewer_keywords

walkthroughs [Reporting Services]

tutorials [Reporting Services]

reports [Reporting Services], creating

Create a basic table report (SSRS tutorial)

In this tutorial, you use the Report Designer tool in Visual Studio / SQL Server Data Tools (SSDT). You create a SQL Server Reporting Services (SSRS) paginated report. The report contains a query table, created from data in the [!INCLUDE sssampledbobject-md] database.

As you progress in this tutorial, you're going to learn how to:

create a report project.
set up a data connection.
define a query.
add a table data region.
format the report.
group and total fields.
preview the report.
optionally publish the report.

Requirements

Your system must have the following components installed to take this tutorial:

[!INCLUDEmsconame-md] SQL Server database engine.
SQL Server 2016 Reporting Services or later (SSRS).
The [!INCLUDE sssampledbobject-md] database. For more information, see Adventure Works Sample Databases.
SQL Server Data Tools for Visual Studio along with the Reporting Services extension installed to enable access to the Report Designer.

You must also have read-only permissions to retrieve data from the [!INCLUDE sssampledbobject-md] database.

Estimated time to complete the tutorial: 30 minutes.