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.

Options

  • 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.

    Note

    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.

See Also

Reference

Report Designer F1 Help
Dataset (Data Options Tab, Report Designer)
Dataset (Fields Tab, Report Designer)
Dataset (Filters Tab, Report Designer)
Dataset (Parameters Tab, Report Designer)

Other Resources

Defining Report Datasets

Help and Information

Getting SQL Server 2005 Assistance