| 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 | 05/21/2024 | |||
| ms.service | reporting-services | |||
| ms.subservice | reporting-services | |||
| ms.topic | conceptual | |||
| ms.custom | updatefrequency5 | |||
| helpviewer_keywords |
|
The tutorial helps you create a SQL Server Reporting Services (SSRS) paginated report. As you progress through the tutorial, you learn how to use the Report Designer tool in Visual Studio / SQL Server Data Tools (SSDT) to create a query table 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
- Publish the report
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.
- Lesson 1: Create a report server project (Reporting Services)
- Lesson 2: Specify connection information (Reporting Services)
- Lesson 3: Define a dataset for the table report (Reporting Services)
- Lesson 4: Add a table to the report (Reporting Services)
- Lesson 5: Format a report (Reporting Services)
- Lesson 6: Add grouping and totals (Reporting Services) Reporting Services tutorials
More questions? Try asking the Reporting Services forum.