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.

Lesson 1: Creating a Report Server Project (Reporting Services)

Lesson 2: Specifying Connection Information (Reporting Services)

Lesson 3: Defining a Dataset for the Table Report (Reporting Services)

Lesson 4: Adding a Table to the Report (Reporting Services)

Lesson 5: Formatting a Report (Reporting Services)

Lesson 6: Adding Grouping and Totals (Reporting Services)

Reporting Services Tutorials (SSRS)

Community Additions