Value Element (QueryParameter) (RDL)

Contains the value to pass to the data source.

Syntax

<QueryParameter Name="...">
    ...
      <Value>...</Value>
    ...
</QueryParameter>

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

QueryParameter

Child element

None

Remarks

The Value element contains an expression that evaluates to a variant that may be passed to the data source. The expression can include report parameters but it cannot contain references to report elements, fields in the data set used for the report, or aggregate functions.

The order in which the report parameters are listed is important. If you use a parameterized query to supply a list of valid values or a default value in a report parameter, any report parameters used by this query must be listed before the report parameter that uses this query.

For example, if a report parameter named City uses a query that maps a query parameter to a report parameter named Region, the Region report parameter must appear in the list of report parameters before the City report parameter. This allows the list of values for City to vary depending on the value chosen for Region.

See Also

Reference

Report Definition XML Elements

Help and Information

Getting SQL Server 2005 Assistance