Add, Rearrange and Delete Table Columns

Introduction

Adding and moving columns within a table are accomplished by clicking, dragging and dropping objects into the desired place. The shadow of your mouse while you are dragging the object and hovering over the table determines if you are adding or moving the object next to, above, below or instead of the other columns.

Video

Step-by-Step Guide

Prerequisite: Have your report open and make sure it is in Design Mode. If necessary, refresh your report.

Shadow Location and Meaning table:

Shadow Action Screenshot Meaning
Shadow on the left of the cell Screenshot of InfoView adding data to the left A new column with the new information will be created to the  left of the existing column
Shadow on the right of the cell Screenshot of InfoView adding data to the right A new column with the new information will be created to the  right  of the existing column
Shadow on the top of the cell Screenshot of InfoView adding data above A new row with the new information will be created above the existing row
Shadow on the bottom of the cell Screenshot of InfoView adding data below A new row with the new information will be created below the existing row
Shadow in the middle of the cell Screenshot of InfoView replacing data in a column The new information will be inserted into the existing column/row, replacing the previous contents

A. Add Columns to an Existing Table

1. Navigate to the Available Objects data palette by clicking the icon in the left-hand panel

Screenshot of InfoView finding the available objects palette

2. Select the object from the list that you want to add to your report

3. Click and drag the object to the place that you want it in your table and hover over the space until you see the appropriate shadow

Shown here: I want to add the course number column between the Academic Year and the Course Title.

Screenshot of InfoView drag and drop a column

4. Drop the object and confirm that it has landed in the correct place.

5. If necessary, use the undo button or the undo key-command ctrl+Z (command + click on a mac) to reverse your changes.

Note: Saving your report resets the "undo" queue, so they only work to reverse changes that occured after your last save.

Screenshot of InfoView showing the location of the undo button

B. Move Columns in an Existing Table

1. Click on one of the data fields in the column that you want to move (not the header)

2. Drag the column to the place that you want it and hover over the space until you see the appropriate shadow

3. Drop the object and confirm that it has landed in the correct place.

Note: Your table may resort itself automatically and may also show you a page that is not the first page. If desired, go back to the first page and sort your results by following the instructions in the Apply a Sort Guide.

4. If you have renamed your headers, you may have to move them after moving the contents.

5. If necessary, use the undo button or the undo key-command ctrl+Z (command + click on a mac) to reverse your changes.

(See A. 5. above for screenshots.)

C. Delete Columns from an Existing Table

1. Click on one of the data fields in the column that you want to move (not the header)

2. Either:

a) Drag and drop it back to the Available Objects data palette, or 

b) Right click (command + click on a mac) and select "Delete"

Screenshot of InfoView right click menu options with delete highlighted