| title | Create a Basic Table Report (SSRS Tutorial) | Microsoft Docs | |||
|---|---|---|---|---|
| ms.date | 04/16/2019 | |||
| ms.prod | reporting-services | |||
| ms.prod_service | reporting-services-native | |||
| ms.technology | reporting-services | |||
| ms.topic | conceptual | |||
| helpviewer_keywords |
|
|||
| ms.assetid | 3b539b4b-26f2-4c0b-b506-80f175679a46 | |||
| author | maggiesMSFT | |||
| ms.author | maggies |
In this tutorial, you use Report Designer in SQL Server Data Tools to create a basic [!INCLUDEssrscurrent-md] paginated report with a table, based on the [!INCLUDEsssampledbadventureworks2016_md] database. You can also create [!INCLUDEssrsnoversion_md] paginated reports with Report Builder.
As you go through this tutorial, you will create a report project, set up connection information, define a query, add a Table data region, group and total some fields, and preview the report.
Your system must have the following installed to use this tutorial:
-
[!INCLUDEsscurrent-md] database engine.
-
[!INCLUDEssRSCurrent].
-
The [!INCLUDEssSampleDBAdventureworks2017_md] database. For more information, see Adventure Works Sample Databases).
-
Make sure the Visual Studio SQL Server Data Tools option and the Visual Studio Extension for "Reporting Services" are installed so you have the SSRS Report Designer.
You must also have read-only permissions to retrieve data from the [!INCLUDEsssampledbadventureworks2016] database.
Estimated time to complete the tutorial: 30 minutes.
Lesson 1: Creating a Report Server Project (Reporting Services)
Lesson 2: Specifying Connection Information (Reporting Services)
Lesson 3: Defining a Dataset for the Table Report (Reporting Services)
Lesson 4: Adding a Table to the Report (Reporting Services)
Lesson 5: Formatting a Report (Reporting Services)
Lesson 6: Adding Grouping and Totals (Reporting Services)
More questions? Try asking the Reporting Services forum