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 2016 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.