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,
- Right-click on a column gripper where you want to insert a column.
![Tablix listed in item panel](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/right-click-and-open-menu-to-insert-column.png)
- Click on
Insert Column
and then click Left
or Right
.
![Tablix listed in item panel](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/insert-column-menu-options.png)
By selecting a respective cell,
- Right-click a cell in the tablix where you want to insert a column.
![Tablix listed in item panel](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/open-cell-menu-to-insert-column.png)
- Click on
Insert Column
and then click Left
or Right
.
![Tablix listed in item panel](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/insert-column-menu-options-in-cell.png)
Now, a new column will be added above or below of the target column.
![Tablix item with properties view](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/insert-column-output.png)
Insert a column in a group
You can add a column in a group in two ways:
By selecting respective row,
- Right-click on a column group gripper where you want to insert a column.
![Tablix listed in item panel](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/right-click-and-open-menu-to-insert-column-in-a-column-group.png)
- Click on
Insert Column
.
![Tablix listed in item panel](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/insert-column-in-a-column-group-menu-options.png)
By selecting a respective cell,
- Right-click a column group cell in the tablix where you want to insert a column.
![Tablix listed in item panel](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/open-cell-menu-to-insert-column-in-a-group.png)
- Click on
Insert Column
![Tablix listed in item panel](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/insert-column-in-group-menu-options-in-cell.png)
The following options will be listed in the Insert Column
menu.
- 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](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/insert-column-inside-group-left.png)
- 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](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/insert-column-inside-group-right.png)
- 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](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/insert-column-outside-group-left.png)
- 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](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/insert-column-outside-group-right.png)
Delete a column
You can delete a column in two ways:
By selecting respective column,
- Select a column that you want to delete.
![Tablix item with properties view](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/select-a-column-to-delete.png)
- Right-click on the column gripper of the respective column.
![Tablix item with properties view](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/open-delete-menu-of-selected-column.png)
- Then click on the
Delete Columns
in the context menu.
By selecting a respective cell,
- Right-click a cell in the tablix where you want to delete a column.
![Tablix item with properties view](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/open-delete-menu-of-selected-cell-to-delete-column.png)
- 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](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/delete-column-ouput.png)
Delete a column from a group
- Right-click a column group cell in the column group of a tablix.
![Tablix item with properties view](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/open-delete-menu-of-selected-cell-column-group.png)
- Then click
Delete Columns
.
Now, a selected column will be deleted from the tablix.
![Tablix item with properties view](/enterprise-reporting/assets/on-premise/images/report-designer/report-items/tablix/delete-column-group-ouput.png)