Database Reference
In-Depth Information
• Access to a Microsoft SQL Server 2012 Database Engine instance with the
Adventure Works DW 2012 sample database deployed
• SQL Server Data Tools (SSDT) or Visual Studio 2010
Microsoft SQL Server 2012 is available in a 180-day trial version (which includes
SQL Server Data Tools) from the location at
http://www.microsoft.com/en-
us/download/details.aspx?id=29066
and Adventure Works DW 2012 sample
database is available for download from the location at
http://msftdbprodsamples.
codeplex.com/releases/view/55330
.
Tutorial scenario
In this exercise, you will step into the shoes of an IT developer working at a
fictitious bike retailer called Adventure Works. You have been tasked with
creating a report for the Internet sales department that will provide information
on year-over-year sales trends. After developing the report, you will need to deploy
it to the company's existing standalone report server, where it can be accessed by
users in the sales department.
Creating a Reporting Services project
Since we are using SQL Server Data Tools (instead of Report Builder) for this
exercise, the first step is to create a Reporting Services project:
1.
Open SQL Server Data Tools (SSDT).
2.
From the menu bar across the top, navigate to
File
|
New
|
Project
.
3.
In the
New Project
window, navigate to
Business Intelligence
|
Reporting
Services
|
Report Server Project
.
4.
Enter a name and location for the project, and click on
OK
to create and open
the project.
