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:
Open SSDT and create a new project. Under Business Intelligence project templates, choose Report Server Project. Name the project
Chapter 09 SSRS
.The new project will be created with three folders: Shared Data Sources, Shared Datasets, and Reports.
Right-click on the Reports folder and click on the Add New Report option from the pop-up menu.
Now, the Report Wizard will appear. In the Select Data Source window, create a connection to the
AdventureWorksDW2012
database and name the connectionAdventureWorksDW2012
. Check the Make this a Shared Data Source checkbox option.The following screenshot shows the Report Wizard and its connection properties:
In the Design the Query window, you can...