Edit

Change an item within a cell in a paginated report (Report Builder)

  • Article

Applies to: ✅ Microsoft Report Builder (SSRS) ✅ Power BI Report Builder ✅ Report Designer in SQL Server Data Tools

In paginated reports, only a non-container item, such as a text box, line, or image, can be replaced by a new report item. For example, you can drag a table into a text box to replace the text box with a table.

If the cell contains a container item such as a rectangle, list, table, or matrix, the new item is added to the containing item instead of replacing it. To replace a container item with a new item, delete the container. Deleting the container item replaces it with a text box, which you can then replace with another item.

By default, all cells in a table, matrix, or list data region contain a text box.

Note

You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.

To change an item within a cell

  • On the Insert tab, in the Data Regions or Report Items group, click the item that you want to add to the report, and then click the report. The item is added to the report.

Note

The Image Properties dialog box opens when you drag an image report item to a cell, where you can set properties such as the source of the image before the image is added to the cell.

See Also

Images, Text Boxes, Rectangles, and Lines (Report Builder and SSRS)
Tables, Matrices, and Lists (Report Builder and SSRS)