DataSetReference Element (RDL)

  • Article

Defines a dataset that contains a list of valid parameter values or a default parameter.

Syntax

<ValidValues> <!-- or <DefaultValue> -->
    ...
        <DataSetReference>
          <<DataSetName>...</DataSetName>
          <ValueField>...</ValueField>
          <LabelField>...</LabelField>
        </DataSetReference>
    ...
</ValidValues> <!-- or /DefaultValue>

Element Characteristics

Characteristic Description

Data type and length

None

Default value

None

Cardinality

0-1: Optional element that can occur once or not at all. See "Remarks" for additional information.

Element Relationships

Relationship Element

Parent elements

DefaultValue, ValidValues

Child elements

DataSetName, LabelField, ValueField

Remarks

The ValidValues element can have only one child element: DataSetReference or ParameterValues. When you use DataSetReference as a child element of ValidValues, the query within the dataset referenced by the DataSetName element is used to get a list of possible values for the parent report parameter.

The DefaultValue element can also have only one child element: DataSetReference or Values. When you use DataSetReference as a child element of DefaultValue, the query for the dataset referenced by the DataSetName element is used to get the default value for the parent report parameter. The default is the first value in the field specified by the ValueField element.

See Also

Reference

Report Definition XML Elements
ParameterValues Element (RDL)
Values Element (RDL)

Help and Information

Getting SQL Server 2005 Assistance