Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

UsedInQuery Element (RDL)

SQL Server 2005

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


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

Characteristic Description

Data type and length

String

Default value

Auto

Cardinality

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

Relationship Element

Parent element

ReportParameter

Child element

None

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.

Community Additions

ADD
Show:
© 2015 Microsoft