Export (0) Print
Expand All
Expand Minimize

Dataset (Query Tab, Report Designer)

Use the Query tab of the Dataset dialog box to display and modify the query within the dataset.

The following table describes the other tabs in the Dataset dialog box.

Topic Description

Dataset (Data Options Tab, Report Designer)

Describes the Data Options tab of the Dataset dialog box.

Dataset (Fields Tab, Report Designer)

Describes the Fields tab of the Dataset dialog box.

Dataset (Filters Tab, Report Designer)

Describes the Filters tab of the Dataset dialog box.

Dataset (Parameters Tab, Report Designer)

Describes the Parameters tab of the Dataset dialog box.

Name

Type a name for the dataset. The name cannot be the same as a name for any data region or group in the report.

Data source

Select the data source on which to base the dataset. To create a new data source, select New Data Source. To edit the selected data source, click the data source builder (...) button.

Command type

Select the type of command or query to use for the dataset. Select Text to run a query to retrieve data from the database, select StoredProcedure to execute a stored procedure by name, or select TableDirect to query a table by name. Text is selected by default and is used for most queries.

Query string

Type a query if Command type is set to Text. If Command type is set to StoredProcedure or TableDirect, type the name of a stored procedure or table. A stored procedure must return a single result set.

ms178261.note(en-US,SQL.90).gifNote:
If you used a query designer to build a query, the text of the query appears under Query string.

Timeout

Type the number of seconds until the query times out. The default is 30 seconds. The value for Timeout must be empty or greater than zero. If it is empty, the query does not time out.

Community Additions

ADD
Show:
© 2014 Microsoft