Wednesday, July 16, 2014

SSRS Tutorial : Creating the Shared Data Source

In this chapter, you will create a shared data source for the AdventureWorksDW2008R2 SQL Server relational database. It is a best practice to create a single shared data source per database and then reference it in reports.
1.       In Solution Explorer, in the Sales Reports project, right-click the Shared Data Sources folder, and then select Add New Data Source.
2.       In the Shared Data Source Properties window, in the Name box, replace the text with AdventureWorksDW2008R2.
3.       To construct the connection string, click Edit.
4.       In the Connection Properties window, configure the connection properties based on the following, and then click OK.

Property
Value
Server Name
SqlServerSample
Database Name
AdventureWorksDW2008R2

 
5.       In the Shared Data Source Properties window, click OK.
6.       To save the entire solution, on the File menu, select Save All.


KeyWords: SSRS Tutorial, SSRS Shared Data source.

No comments:

Post a Comment