Export (0) Print
Expand All
Expand Minimize

DataSetReference Element (RDL)

SQL Server 2005

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


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

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.

Relationship Element

Parent elements

DefaultValue, ValidValues

Child elements

DataSetName, LabelField, ValueField

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.

Community Additions

ADD
Show:
© 2015 Microsoft