Databases Reference
In-Depth Information
With your data source created, you now need to add a dataset for the report. For each data source, you
can create one or more datasets. Each dataset specifies the fields from the data source that you would
like to use in the report. The dataset also contains, among other things, the query used to get the data
and any query parameters to filter the data.
7.
In the Report Data window, right-click the Datasets node, and select Add Dataset from the
context menu. Doing so opens the Dataset Properties window, shown in Figure
6-11
.
8.
The Query page of the Dataset Properties window allows you to do two primary things:
specify the data source on which this dataset is based, and specify the query type and
associated query. For this example, base your dataset on the data source you created
earlier. The query type is Text, meaning that you type a T-SQL statement in the Query field.
For this example, four tables will be joined to return contact information, such as name
and address, so enter the
SELECT
statement shown in Figure
6-11
. The Name of the dataset
defaults to DataSet1, which is fine for this example. Click OK.
Figure 6-11.
The Dataset Properties dialog
There is nothing else you need to do for your dataset; you're ready to define and lay out your report.
