Create a Basic Table Report (SSRS Tutorial)
In this tutorial, you use Report Designer in SQL Server Data Tools to create a basic Reporting Services paginated report with a table, based on the AdventureWorks2014 database. You can also create Reporting Services 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:
Microsoft SQL Server database engine.
SQL Server 2016 Reporting Services (SSRS) in native mode.
The AdventureWorks2014 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 AdventureWorks2014 database.
Estimated time to complete the tutorial: 30 minutes.
More questions? Try asking the Reporting Services forum