CommandText Element (RDL)

Specifies the query that the report server executes to retrieve data for the report.

Syntax

<Query>
    ...
    <CommandText>...</CommandText>
    ...
</Query>

Element Characteristics

Characteristic	Description
Data type and length	String
Default value	None
Cardinality	1-1: Required element that occurs once and only once.

Element Relationships

Relationship	Element
Parent element	Query
Child element	None

Remarks

The CommandText element contains an expression that evaluates to a statement that the data source can use to retrieve data (for example, a Transact-SQL query). The type of query contained in the CommandText element is specified in the CommandType element.

See Also

Reference

Report Definition XML Elements
CommandType Element (RDL)

Help and Information

Getting SQL Server 2005 Assistance