Skip to main content
Skip table of contents

IMOS - 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 HeadingFontBackground, and other formatting, click the field name in the Report Designer panel and edit the Column Properties fields.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.