Add, Move, or Delete a Table, Matrix, or List (Report Builder and SSRS)
Applies To: SQL Server 2016
In a Reporting Services paginated report, a data region displays data from a report dataset. Data regions include table, matrix, list, chart, and gauge. To nest one data region inside another, add each data region separately, and then drag the child data region onto the parent data region.
The simplest way to add a table or matrix data region to your report is to run the New Table or New Matrix Wizard. These wizards will guide you through the process of choosing a connection to a data source, arranging fields, and choosing the layout and style. The wizards are only available in Report Builder.
On the Insert tab, click Table or Matrix, and then click Table Wizard or Matrix Wizard.
Follow the steps in the New Table or New Matrix wizard.
On the Home tab, click Run to see the rendered report.
On the Run tab, click Design to continue working on the report.
On the Ribbon, in the Data Regions group, click the data region to add.
Click the design surface, and then drag to create a box that is the desired size of the data region.
Drag a report dataset field from the Report Data pane onto a data region cell. The data region is now bound to data from the report dataset.
For a tablix data region, right-click the corner handle. For a chart or gauge data region, click in the data region.
A selection handle and eight resizing handles appear.
For nested data regions, right-click in the nested data region, click Select, and then select the report item you want. To verify which report item is selected, use the Properties pane. The name of the selected item on the design surface appears in the toolbar of the Properties pane.
To move a data region, click the selection handle of the data region and drag it. Use snaplines to align it to existing report items.
If the ruler is not visible, click the View tab and select the Ruler option.
Alternatively, use the arrow keys to move the selected data region on the design surface.
- Select the data region, right-click in the data region, and then click Delete.