Create a Basic Table Report (SSRS Tutorial)

Create a Basic Table Report (SSRS Tutorial)


Applies To: SQL Server 2016 Preview

This tutorial is designed to help you create a basic table report based on the AdventureWorks2012 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.


To complete this tutorial, you must be running Reporting Services in native mode. If you are running Reporting Services in SharePoint integrated mode, the steps that use report server URLs do not work. For more information about Reporting Services modes, see Reporting Services Report Server.

Your system must have the following installed to use this tutorial:

  • Microsoft SQL Server 2016  database engine.

  • The AdventureWorks2012 database. For more information, see Adventure Works for SQL Server 2012 (Adventure Works for SQL Server 2012) ( For more information about support for SQL Server sample databases and sample code for SQL Server Express, see Databases and Samples Overview on the CodePlex Web site.

  • SQL Server 2016 Reporting Services (SSRS).

  • SQL Server SQL Server Data Tools (SSDT).


    SQL Server Data Tools is not supported on Itanium-based computers. However, support for SQL Server Data Tools is available for x64-based computers. If the SQL Server sample databases have been deployed on an Itanium-based computer, use BI Development Studio on either an x86-based or x64-based computer to modify and run the samples.

You must also have read-only permissions to retrieve data from the AdventureWorks2012 database.

Community Additions

© 2016 Microsoft