Search results
PDF

Insert or Delete a Column

You can insert or delete columns in the tablix to organize data in your report in a better way.

Insert a column

You can add a column in two ways:

By selecting respective column,

  1. Right-click on a column gripper where you want to insert a column. Tablix listed in item panel
  2. Click on Insert Column and then click Left or Right. Tablix listed in item panel

By selecting a respective cell,

  1. Right-click a cell in the tablix where you want to insert a column. Tablix listed in item panel
  2. Click on Insert Column and then click Left or Right. Tablix listed in item panel

Now, a new column will be added above or below of the target column.

Tablix item with properties view

Insert a column in a group

You can add a column in a group in two ways:

By selecting respective row,

  1. Right-click on a column group gripper where you want to insert a column. Tablix listed in item panel
  2. Click on Insert Column. Tablix listed in item panel

By selecting a respective cell,

  1. Right-click a column group cell in the tablix where you want to insert a column. Tablix listed in item panel
  2. Click on Insert Column Tablix listed in item panel

The following options will be listed in the Insert Column menu.

  1. Inside Group - Left - A new column is added inside the target group but in the left position. In the below snap, the Grouping Indicator denotes that the column is added inside the group. Tablix listed in item panel
  2. Inside Group - Right - A new column is added inside the target group but in the right position. In the below snap, the Grouping Indicator denotes that the column is added inside the group. Tablix listed in item panel
  3. Outside Group - Left - A new column is added outside of the target group but in the left position. In the below snap, notice that the Grouping Indicator is shown only for the target group. Tablix listed in item panel
  4. Outside Group - Right - A new column is added outside of the target group but in the right position. In the below snap, notice that the Grouping Indicator is shown only for the target group. Tablix listed in item panel

Delete a column

You can delete a column in two ways:

By selecting respective column,

  1. Select a column that you want to delete. Tablix item with properties view
  2. Right-click on the column gripper of the respective column. Tablix item with properties view
  3. Then click on the Delete Columns in the context menu.

By selecting a respective cell,

  1. Right-click a cell in the tablix where you want to delete a column. Tablix item with properties view
  2. Then click on the Delete Columns in the context menu.

Now, a selected column will be deleted from the tablix.

Tablix item with properties view

Delete a column from a group

  1. Right-click a column group cell in the column group of a tablix. Tablix item with properties view
  2. Then click Delete Columns.

Now, a selected column will be deleted from the tablix.

Tablix item with properties view