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