Export (0) Print
Expand All
Expand Minimize

Value Element (QueryParameter) (RDL)

SQL Server 2005

Contains the value to pass to the data source.


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

Characteristic Description

Data type and length

String

Default value

None

Cardinality

1-1: Required element that occurs once and only once.

Relationship Element

Parent element

QueryParameter

Child element

None

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.

Community Additions

ADD
Show:
© 2015 Microsoft