Udostępnij za pośrednictwem


UsedInQuery Element (RDL)

Indicates whether a report parameter is used in queries within the report.

Syntax

<ReportParameter Name="...">
       ...
        <UsedInQuery>...</UsedInQuery>
    ...
</ReportParameter>

Element Characteristics

Characteristic Description

Data type and length

String

Default value

Auto

Cardinality

0-1: Optional element that can occur once or not at all.

Element Relationships

Relationship Element

Parent element

ReportParameter

Child element

None

Remarks

The UsedInQuery element must contain one of the following string values:

  • True
  • False
  • Auto

You use the UsedInQuery to determine whether queries containing parameters that are associated with the report parameter are executed if the report parameter changes. This impacts whether the parameter can be changed in snapshot reports. Setting the value to Auto indicates that the report server attempts to detect whether the parameter is used in a query.

See Also

Reference

Report Definition XML Elements

Help and Information

Getting SQL Server 2005 Assistance