Database Reference
In-Depth Information
4.
Name the report
Sales Summary
, and click on
Add
to finish creating the
report item, then add it to the
Report Server Project
.
Add New Item dialog box for adding a new report to the Report Server Project
Creating a shared data source
Next, you need to create a data source that contains the connection details to the
source system that contains the Internet sales data on which you need to report.
As you learned in
Chapter 2
,
SSRS - Standard Reporting
, there are two types of data
sources: shared data sources and embedded data sources. For this exercise, you
will create a shared data source pointing to the Adventure Works Sample Data
Warehouse database, as follows:
1.
In the
Solution Explorer
window, right-click on the
Shared Data Sources
folder, and choose
Add New Data Source
.
2.
Name the data source
DW_AdventureWorks
, and confirm that Microsoft SQL
Server is selected as the type of data source.
3.
Click on the
Edit
button to bring up the
Connection Properties
dialog box
shown in the following screenshot.
4.
For the
Server name
property, enter the name of the server or SQL Server
instance that hosts the source database.