VIP - Adding Columns

After you define Report Properties, the Report Designer panel appears with a list of tables containing the fields that you can add as columns to your report. A list of all tables is available in the Data Map.

Adding Columns to a Report

On the Report Designer panel, do the following:

1. To select a table, click it.
   Note: To see all tables in the Report Designer, click Show All Tables.
2. To add columns, use any of these methods from the list of fields in the Report Designer panel:
   • To search for a field in the selected table, type its name in the Search field at the top of the list.
     • To clear the Search field, press Esc.
   • To use a field as a column, select its check box.
     Note: Watch for duplicate fields.
     • To create a range of commencement dates and completion dates of the voyages in your database, use the Voyage Range GMT field from the Voyage Table.
   • To add a custom column, click + at the top of the list.
   • To join a table, after selecting one of the primary tables, hover over it and then click + .
   • To join a field, click  next to the field name.
3. To save the report, click << Report at the top of the list and then click Save.

Selected columns appear in the left pane.

Adjusting Columns in a Report

In a report, you can make any of the following adjustments to columns:

• To sort by a column, click the column heading to Sort Ascending. Click again to Sort Descending. Click again to Clear Sorting.
  
  • To sort multiple columns, press Shift while clicking column headings. Columns sort in the order you click them.

• To change the width of a column, place your pointer at the right end of the column heading and then, when the pointer becomes a double-headed arrow, do one of the following:
  • Drag it to move the split line.
  • Double-click to automatically change the width to fit the longest value in the column.

• To change column sequence, drag the column heading to where you want it in either the columns themselves or the Report Designer panel.

• To change the properties of a column, including Heading, Font, Background, and other formatting, click the field name in the Report Designer panel and edit the Column Properties fields.