How to create a new shared data source connection and add a dataset in
New Data Source by right clicking on Shared Data Sources at Solution Explorer.
- Enter database name
UWSDBDataSore, HumanResources, FRDataMart or etc). Edit the Connection String
Go to the Report Data window. Right mouse click and select "Add Dataset".
Name dataset, in
this case we named it "UWCalendarDate".
Connect dataset with
data source you have just created by clicking on the "New" button.
Name the data
connection the same.
Select "Use shared
data source reference" radio button.
Select the data
source you have just created. Click OK.
- Enter the SQL query for the data source you have just created in the Query
section. Click OK.
are the results from the exercise. Please note the
NEW data source connection
at the Report Data Browser and Solution Explorer Browser. Also note the
NEW dataset for
under the Report Data Browser.