merge-cells-in-a-data-region-report-builder-and-ssrs.md

title	Merge cells in a data region in a paginated report
description	Discover how to merge cells in a data region in a paginated report to combine cells, improve data region appearance, or provide spanning labels for column and row groups in Report Builder.
ms.date	09/25/2024
ms.service	reporting-services
ms.subservice	report-design
ms.topic	how-to
ms.custom	updatefrequency5

Merge cells in a data region in a paginated report (Report Builder)

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

In a paginated report, you can merge cells in a data region to combine cells, improve data region appearance, or provide spanning labels for column groups and row groups.

You can only merge cells within each area of a data region: corner, column headers, group definition (or row headers), and body. You can't merge cells that cross area boundaries. For example, you can't merge a cell in the data region corner area with a cell in the row group area. Read more about Tables, Matrices, and Lists (Report Builder and SSRS).

Note

[!INCLUDEssRBRDDup]

To merge cells in a data region

1. In the data region on the report design surface, click the first cell to merge. Holding the left mouse button down, drag vertically or horizontally to select adjacent cells. The selected cells are highlighted.

2. Right-click the selected cells and select Merge Cells. The selected cells are combined into a single cell.

3. Repeat steps 1 and 2 to merge other adjacent cells in a data region.

Related content

• Tablix Data Region
• Tables (Report Builder and SSRS)
• Create a Matrix
• Create Invoices and Forms with Lists
• Tables, Matrices, and Lists (Report Builder and SSRS)