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.


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)

Next steps

Reporting Services Tutorials

More questions? Try asking the Reporting Services forum