Lesson 1: Creating a Report Server Project in SQL Server Data Tools (Reporting Services)

 

Updated: November 30, 2016

In this lesson, you'll create a report server project and a report definition (.rdl) file in SQL Server Data Tools within Visual Studio.

To create a report with SQL Server Data Tools (SSDT), first you need a report server project where you can save your report definition (.rdl) file and other resource files you need for your report.

In the following lessons, you define a data source for your report, define a dataset, and define the report layout. When you run the report, the data is retrieved and combined with the layout, and then rendered on your screen. From there you can export it, print it, or save it.

  1. Open SQL Server Data Tools.

  2. On the File menu > New > Project.

    ssrs-ssdt-file-01-new-project

  3. Under Installed > Templates > Business Intelligence, click Reporting Services.

    ssrs-ssdt-01-new-rs-project

  4. Click Report Server Project ssrs_ssdt_report_server_project.

    Note: If you don't see the Business Intelligence or Report Server Project options, you need to update SSDT with the Business Intelligence temapltes. See Download SQL Server Data Tools (SSDT)

  5. In Name, type Tutorial.

    By default, it's created in your Visual Studio 2015\Projects folder in a new directory.

    ssrs-ssdt-01-solution-location

  6. Click OK to create the project.

    The Tutorial project is displayed in the Solution Explorer pane on the right.

  1. In the Solution Explorer pane, right-click the Reports > Add > New Item.

    Tip: If you don't see the Solution Explorer pane, on the View menu, click Solution Explorer.

    ssrs_ssdt_add_report

  2. In the Add New Item window, click Report ssrs_ssdt_report.

  3. In Name, type Sales Orders.rdl and then click Add.

    Report Designer opens and displays the new .rdl file in Design view.

    ssrs-ssdt-01-new-report-designer

    Report Designer is a Reporting Services component that runs in SQL Server Data Tools (SSDT). It has two views: Design and Preview. Click each tab to change views.

    You define your data in the Report Data pane. You define your report layout in Design view. You can run the report and see what it looks like in Preview view.

You have successfully created a report project called "Tutorial" and added a report definition (.rdl) file to the report project. Next, you will specify a data source to use for the report. See Lesson 2: Specifying Connection Information (Reporting Services).

Create a Basic Table Report (SSRS Tutorial)

Community Additions

ADD
Show: