| title | Create a Basic Table Report (SSRS Tutorial) | Microsoft Docs | |||
|---|---|---|---|---|
| ms.custom | ||||
| ms.date | 06/15/2016 | |||
| ms.prod | sql-server-2016 | |||
| ms.reviewer | ||||
| ms.suite | ||||
| ms.technology |
|
|||
| ms.tgt_pltfrm | ||||
| ms.topic | get-started-article | |||
| applies_to |
|
|||
| helpviewer_keywords |
|
|||
| ms.assetid | 3b539b4b-26f2-4c0b-b506-80f175679a46 | |||
| caps.latest.revision | 67 | |||
| author | maggiesMSFT | |||
| ms.author | maggies | |||
| manager | erikre |
In this tutorial, you use Report Designer in SQL Server Data Tools to create a basic [!INCLUDEssRSnoversion_md] paginated report with a table, based on the [!INCLUDEssSampleDBAdventureworks2014_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:
-
[!INCLUDEssRSCurrent] in native mode.
-
The [!INCLUDEssSampleDBAdventureworks2014_md] database. For more information, see Adventure Works 2014 Sample Databases).
-
SQL Server Data Tools with the "SQL Server Reporting Services" components installed so you have the Report Designer.
You must also have read-only permissions to retrieve data from the [!INCLUDEssSampleDBAdventureworks2014_md] 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)