DataSetReference Element (RDL)

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