create-a-basic-table-report-ssrs-tutorial.md

title	Create a Basic Table Report (SSRS Tutorial) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	reporting-services-native
ms.topic	conceptual
helpviewer_keywords	walkthroughs [Reporting Services] tutorials [Reporting Services] reports [Reporting Services], creating
ms.assetid	3b539b4b-26f2-4c0b-b506-80f175679a46
author	maggiesMSFT
ms.author	maggies
manager	kfile

Create a Basic Table Report (SSRS Tutorial)

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

Note

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

Requirements

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

• [!INCLUDEmsCoName] [!INCLUDEssCurrent] database engine.

• The [!INCLUDEssSampleDBobject] database. For more information, see Adventure Works for SQL Server 2012 (Adventure Works for SQL Server 2012) (https://go.microsoft.com/fwlink/?LinkId=245471).. For more information about support for [!INCLUDEssNoVersion] sample databases and sample code for [!INCLUDEssExpress], see Databases and Samples Overview on the CodePlex Web site.

• [!INCLUDEssRSCurrent].

• [!INCLUDEssNoVersion] [!INCLUDEssBIDevStudioFull].

  [!NOTE]
  [!INCLUDEssNote64Samp]

You must also have read-only permissions to retrieve data from the [!INCLUDEssSampleDBobject] database.

Tasks

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)

Note

When reviewing tutorials, we recommend that you add Next and Previous buttons to the document viewer toolbar. For more information, see.

See Also

Reporting Services Tutorials (SSRS)