Time for action – creating our first report using SSRS

In this example, you will learn how to create a report server project with SSDT. We will use the AdventureWorks2012 database as source. Perform the following steps to create an SSRS report:

1. Open SSDT and create a new project. Under Business Intelligence project templates, choose Report Server Project. Name the project Chapter 09 SSRS.

2. The new project will be created with three folders: Shared Data Sources, Shared Datasets, and Reports.

3. Right-click on the Reports folder and click on the Add New Report option from the pop-up menu.

4. Now, the Report Wizard will appear. In the Select Data Source window, create a connection to the AdventureWorksDW2012 database and name the connection AdventureWorksDW2012. Check the Make this a Shared Data Source checkbox option.

   Note

   A shared data source can be used in multiple reports and datasets.

   The following screenshot shows the Report Wizard and its connection properties:

   

5. In the Design the Query window, you can...