Database Reference
In-Depth Information
Best practice says that in a production environment, you should use integrated
security. But because that isn't an option with SQL Azure, select the “Specify a
user name and password” option, and enter the username and password of an
account that has access to the appropriate database.
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 data set also contains, among other things, the query used to get the
data and any query parameters to filter the data:
7.
6.
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 8-7.
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
you type a T-SQL statement in the Query field. For this example, you want to
return everything (all rows and columns) from the Users table, so enter the
SELECT
statement shown in Figure 8-7. The Name of the dataset defaults to
DataSet1, which is fine for this example. Click OK.
Figure 8-7.
Dataset Properties dialog
