Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Working with Data Regions

To display data from a report dataset, use a data region. You can drag data regions from the toolbox to the design surface. With a data region, you can group, sort, filter, and aggregate data from a single dataset. You can arrange more than one data region in a report. Data regions can be placed side by side in the report body or in a rectangle container, or can be nested in other data regions. Multiple data regions can provide different views on the same dataset or similar views of different datasets.

The type of data region you choose depends on the amount of data, the range in data values, and what you want to convey in your report. The following list describes the features of each data region:

  • Table   A table displays detail data or data grouped by row. A table has a fixed number of columns. The table expands down the page as needed. You can display all the detail data, row by row, or group the data by creating row groups. Row groups can be nested or adjacent. A row group displays a dynamic row down the page for each value in the group, which is determined at run-time. You can also add static rows for labels or totals. You can add totals to the table or to a specific group.

  • Matrix   A matrix displays data grouped by row and column. A matrix provides similar functionality to cross-tabs and PivotTable dynamic views. A matrix has at least one row group and one column group. The matrix expands across the page for column groups and down the page for row groups. The matrix cells display summary and aggregate values scoped to the intersections of the row and column groups. You can create additional nested groups and adjacent groups. The number of rows and columns in a matrix depend on the values for each group, determined at run-time. You can also add static rows for labels or totals. You can add totals to the table or to a specific group.

  • List   A list displays data in a free-form format. For example, you might use a list to design a form or display both a table and a chart. Arrange text boxes anywhere in the list to create your layout. The list row repeats one time for each value in the dataset.

  • Chart   A chart displays data graphically. Charts help visualize summary and aggregate data. For more information, see Chart Types.

  • Gauge   A gauge displays an indicator within a range of values. Gauges can be used in a table or matrix to show the relative value of a field in a range of values in the data region, for example, as a KPI. You can also add a gauge to the design surface to show a single relative value. Indicators are minimal gauges that convey the state of a single data value at a glance.

  • Map   A map displays data against a geographical background. Maps can be used to visualize summary and aggregate data for each map element, for example, an area, a road, or a city. You can visualize multiple sets of data by adding multiple map layers that are managed independently. For more information, see Planning a Map (Report Builder 3.0).

Working with Tablix Data Regions

Discusses how to use table, matrix, or list data regions, which are all templates of the Tablix data region.

Working with Chart Data Regions

Discusses how to use a chart data region to summarize and display data in a visual format, including specialized charts that are designed for you to include in a table or matrix. For more information, see Sparklines and Data Bars.

Working with Gauge Data Regions

Discusses how to use a gauge data region.

Working with Indicator Data Regions

Discusses how to use a gauge that is an indicator.

Maps

Discusses how to use a map report item to summarize and display data against a geographic background.

Linking Multiple Data Regions to the Same Dataset

Discusses how to use data regions to provide different views of the same data.

Nesting Data Regions

Discusses how and when to nest data regions.

Publishing Report Parts in Report Designer

Discusses how to publish report items in Report Designer.

Community Additions

Show:
© 2015 Microsoft