insert-or-delete-a-row-report-builder-and-ssrs.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
Insert or delete a row in a paginated report	Find out about adding or deleting rows in a tablix data region in a paginated report in Report Builder.	maggiesMSFT	maggies	03/01/2017	reporting-services	report-design	conceptual	updatefrequency5

Insert or delete a row in a paginated report (Report Builder)

[!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes]

You can add or delete rows in a tablix data region in a paginated report. The tablix data region can be a table, a matrix, or a list. The following procedures do not apply to the chart and gauge data regions.

In a tablix data region, you can add rows that are associated with a group (inside a group) or that are not associated with a group (outside a group). A row that is inside a group repeats once per unique group value. For example, a row inside a group based on the value in a data column that contains color names, repeats once per distinct color name. For nested groups, a row can be outside the child group but inside the parent group. In this case, the row repeats once for each unique value in the parent group.

Note

[!INCLUDEssRBRDDup]

To select a data region so the row and column handles appear

• In Design view, click the upper left corner of the tablix data region so that column and row handles appear above and next to it.

  For more information about data region areas, see Tables, Matrices, and Lists (Report Builder and SSRS).

To insert a row in a selected data region

• Right-click a row handle where you want to insert a row, click Insert Row, and then click Above or Below.

  - or -

• Right-click a cell in the data region where you want to insert a row, click Insert Row, and then click Above or Below.

To delete a row from a selected data region

• Select the row or rows that you want to delete, right-click the handle for one of the rows you selected, and then click Delete Rows.

  - or -

• Right-click a cell in the data region where you want to delete a row, and then click Delete Rows.

To insert a row in a group in a selected data region

• Right-click a row group cell in the row group area of a tablix data region where you want to insert a row, click Insert Row, and then click Above - Outside Group, Above - Inside Group, Below - Inside Group, or Below - Outside Group.

  A row is added either inside or outside the group represented by the row group cell you clicked on.

To delete a row from a group in a selected data region

• Right-click a row group cell in the row group area of a tablix data region where you want to delete a row, and then click Delete Rows.

See Also

Tablix Data Region (Report Builder and SSRS)
Understanding Groups (Report Builder and SSRS)
Tables (Report Builder and SSRS)
Matrices (Report Builder and SSRS)
Lists (Report Builder and SSRS)
Tables, Matrices, and Lists (Report Builder and SSRS)