Understanding Reporting Services - Microsoft Business Intelligence Tools for Excel Analysts - page 237

Figure 12-12: Shared Dataset Properties dialog box.

2. Select a query type: Text, Table, or Stored Procedure.

Text: Allows you to build your own custom SQL statement to get the results you need

●

Table: Allows you to point an existing table on the data source

●

Stored Procedure: Allows you to use the results from an existing stored procedure

●

For this example, we selected Text.

3. Click the Query Designer button to build your query.

The Query Designer window opens. (Refer to Figure 12-5.)

You can also enter the query for the dataset directly in the Query box (shown in
Figure 12-12) to bypass the Query Designer.

Tip

4. In the Query Designer window, choose the tables and views you want to add to your query
and select the columns that will appear in the report. Click OK to close the Query Designer
window.

5. Click OK in the Shared Dataset Properties dialog box to finalize your new dataset.

At this point, you can navigate to the Shared Datasets folder in the Solution Explorer to see
your newly created shared dataset. (See Figure 12-13.)