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