Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide

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 ...