Change an Item Within a Cell (Report Builder and SSRS)

 

Applies To: SQL Server 2016

In Reporting Services 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.

System_CAPS_ICON_note.jpg Note


You can create and modify paginated report definition (.rdl) files in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items.

  • 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.
System_CAPS_ICON_note.jpg 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.

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

Community Additions

ADD
Show: