CommandType Element (RDL)
Indicates the type of query that is contained in the CommandText element.
Syntax
<Query>
...
<CommandType>...</CommandType>
...
</Query>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type and length |
String |
Default value |
Text |
Cardinality |
0-1: Optional element that can occur once or not at all. |
Element Relationships
| Relationship | Element |
|---|---|
Parent element |
|
Child element |
None |
Remarks
The value for the CommandType element is restricted to one of the following strings.
| Value | Description |
|---|---|
Text |
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 XML Elements
CommandText Element (RDL)