CommandType Element (RDL)
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
Indicates the type of query that is contained in the CommandText element.
Datatype Characteristics
| Characteristic | Description |
|---|---|
Data type and length |
String |
Default value |
Text |
Element Relationships
| Relationship | Element |
|---|---|
Parent elements |
|
Child elements |
None |
Remarks
The value for the CommandType element is restricted to one of the following strings.
| Value | Description |
|---|---|
Text (Default) |
Indicates that the value is a text string to pass to the data source, for example, a Transact-SQL query. |
StoredProcedure |
Indicates that the value is the name of a stored procedure to execute. The stored procedure must return a single result set. |
TableDirect |
Indicates that the value is the name of a table from which to retrieve data. All data from the table is returned. |
See Also
Reference
Report Definition Language XML Schema
Report Definition XML Elements
Concepts
Report Definition Language Data Types
Other Resources
Development (Reporting Services)
Querying and Defining Report Data (Reporting Services)