Create a Basic Table Report (SSRS Tutorial)
Updated: April 18, 2016
Applies To: SQL Server 2016
This tutorial is designed to help you create a basic table report based on the AdventureWorks2014 database using Report Designer. You can also use Report Builder or the Report Wizard to create reports. In 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.