Database Reference
In-Depth Information
How to do it...
The steps to complete this recipe are as follows:
Creating a dataset
You must first create the dataset. The dataset is the result of a query to the data source and
is created in the Report Builder application. Perform the following steps:
1. Launch the Report Builder application using the
Report Manager Website
option
by navigating to
http://<ServerName>/Reports
(substitute the URL with
your specific environment values) and then click on
Report Builder
.
2. Close the
Getting Started
page. Ensure that the
Home
tab is selected. Under
Re-
port Data
, click on
New
and select
Data Source…
.
3. On the
General
tab, type a name for the data source. Ensure that
Use a shared
connection or report model
is selected and click on
Browse…
, as shown in the
following screenshot: