| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | helpviewer_keywords | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Create a basic table report (SSRS tutorial) |
Use the Report Designer tool in Visual Studio / SQL Server Data Tools (SSDT) and then create a SQL Server Reporting Services (SSRS) paginated report. |
kfollis |
kfollis |
09/25/2024 |
reporting-services |
reporting-services |
tutorial |
|
|
This tutorial is a six-step process that helps you create a SQL Server Reporting Services (SSRS) paginated report. 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.
The six parts in this tutorial show you 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.
Install or configure the following components and permissions:
- [!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 and the Reporting Services extension for access to the Report Designer.
- Read-only permissions to retrieve data from the [!INCLUDE sssampledbobject-md] database.
Estimated time to complete the tutorial: 30 minutes.
- Step 1: Create a report server project (Reporting Services)
- Step 2: Specify connection information (Reporting Services)
- Step 3: Define a dataset for the table report (Reporting Services)
- Step 4: Add a table to the report (Reporting Services)
- Step 5: Format a report (Reporting Services)
- Step 6: Add grouping and totals (Reporting Services)
- Reporting Services tutorials
- Try asking the Reporting Services forum.