Export (0) Print
Expand All

How to: Associate a Data Region with a Dataset

A data region displays data from a report dataset in a report. Adding a field from a dataset to a table, matrix, list, chart, or gauge, or selecting a spatial field or an analytical field from a dataset for a map, links the data region to that dataset.

To associate a data region with a dataset by using fields

  1. In Design view, click the data region to select it.

  2. From the Report Data pane, drag a field from a dataset, and drop the field to the appropriate drop zone in the data region.

    NoteNote

    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.

    NoteNote

    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 Dataset.

To associate a data region with a dataset by using properties

  1. In Design view, right-click the data region and then click Tablix Properties, Chart Properties, or Gauge Panel Properties.

  2. In Dataset name, select a dataset from the drop-down list.

To associate a map layer with a dataset by using properties

  1. In Design view, right-click the map to display the layer panel, right click the layer, and then click Layer Properties.

  2. In Dataset name, select a dataset from the drop-down list that contains spatial data.

Community Additions

Show:
© 2015 Microsoft