Table data region consists of rows and columns that organize data. You can add data in a table either by dragging and dropping fields from the dataset or by using ellipsis available in every table cell (text box). When you add data in a cell in the detail row, a label is automatically added for the table header.
Let us assume that we have a report that displays Product details in a Table data region – Product ID, Name, Unit Price, and Supplier ID fields, similar to the following.
Use the following steps to group table details by category id.
After you complete the above steps, you will have a report that looks similar to the following.
Data in table cells can be merged using Auto Merge Mode property which provides three options - Never, Always, and Restricted. The detail cells with same data values and with Auto Merge Mode property set to:
Let us assume that we have a report that displays Product details in a Table data region – Product ID, Name, Unit Price, and Supplier ID fields, similar to the following.
Use the following steps to merge the cells in the Table data region with similar supplier ids.
After you complete the above steps, you will have a report that looks similar to the following.