V1
V1

Table

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.

Add Groups

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.

  1. Right-click any text box (cell) in the details row of the table to view options in the context menu.
  2. Go to Group and select Insert Group. This adds a row group above and below the details row.

  3. In the first text box of the added row group, we will display CategoryID field. Note that the table groups are also displayed in the adorner on the right side of the Table data region.
  4. From the adorner on the right side of the table, select the Table1_Group1 row group and go to the Properties pane.
  5. In the Group Expressions property, click Show Items and then select Add Item.
  6. Click the radio button to display the fields and select the CategoryID field.

After you complete the above steps, you will have a report that looks similar to the following.

       

Merge Cells

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:

  • Never: are not merged.
  • Always: are merged.
  • Restricted: are merged only if the corresponding cells in previous columns are similarly merged.
    If for example, cells in Column 2 (with same data values) are set 'Restricted' and the corresponding cells (with same data values) in previous column (Column 1) are set 'Never', then cells in Column 2 are not merged.

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.

  1. Select the SupplierID textbox in the details row.
  2. Go to the Properties pane and set Auto Merge Mode property to Always. This merges the cells in the Supplier ID column with similar supplier ids.

After you complete the above steps, you will have a report that looks similar to the following.