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.
Describes the Data Options tab of the Dataset dialog box.
Describes the Fields tab of the Dataset dialog box.
Describes the Filters tab of the Dataset dialog box.
Describes the Parameters tab of the Dataset dialog box.
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.
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.
If you used a query designer to build a query, the text of the query appears under Query string.
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.