How to: Associate a Data Region with a Dataset (Report Builder 2.0)
A data region can be associated with only one dataset. When you use a Chart data region, you can drag fields into the series, category, or data field drop-zones. When you use a Gauge data region, you can drag fields into the data field drop-zone. When you use a Tablix data region, you can drag fields to the Data area or to the Row Groups or Column Groups panes.
To associate a data region with a dataset by using fields
In Design view, click the data region to select it.
From the Report Data pane, drag a field from a dataset, and drop the field to the appropriate drop zone in the data region.
Note
The dataset for a data region is set by the first field that you drag onto the data region. If a field that has been dragged to the data region is removed, the DataSetName property remains set to the dataset that the field belonged to. To change it, follow the steps for associating a data region with a dataset using properties.
Note
Not all Field properties can be used for all data sources. The Value and IsMissing properties are defined for all data sources. Other properties (such as BackgroundColor, FontFamily, and TextDecoration) are only supported for Analysis Services data sources if the data source provides the values. For more information, see Using Extended Field Properties for an Analysis Services Database (Report Builder 2.0).
To associate a data region with a dataset by using properties
In Design view, right-click the data region and then click Tablix Properties, Chart Properties, or Gauge Panel Properties.
In Dataset name, select a dataset from the drop-down list.