IMOS On-Prem - Creating a Vessel Position and Voyage TCE Report in the Report Editor

 This is a Key Topic, with high value for all users.

Note: To create, edit, and copy Report Editor reports, the Report Editor (Legacy) - Create/Edit Reports Module Right must be selected for you in Security.

In this example, we will create a simple custom Vessel Position report that will also display the estimated and actual TCE for each active voyage.

Creating the Report

To create this report, complete each section of the Report Editor:

1. On the IMOS menu, click Reports.
2. Click New, then click Report (Legacy).

Basic Information

1. Type a Title and Description for the report.
2. Select a dataset to serve as the data source for this report.This report will reference vessel position data, therefore select the Vessel Position Report dataset.
3. In the Options section, select the Allow other users to run this report check box. This makes the report public so other users to run it.

Columns

From the Available Columns list, select the following columns to include in the report:

• Voyage.Voyage No.
• Cargo.Counterparty
• Cargo.Cargo Name
• Cargo.Laycan From
• Cargo.Laycan To
• Port.Name
• Port Function
• Port ETA
• Port ETD
• Port Arr ROB
• Voyage.(Est) Voyage TCE
• Voyage.(Act.) Voyage TCE

Filters

• Using Voyage.Status, filter voyages which are neither active nor scheduled. 

Sorting/Groups

• Group the results by vessel name using Voyage.Vessel Name, then sort them in ascending order starting with the voyage number (Voyage.Voyage No.), then the ETA of the itinerary ports (Port ETA).

Aggregate Functions

• Calculate the average value of the estimated (Voyage.(Est) Voyage TCE) and actual (Voyage.(Act.) Voyage TCE) TCEs across your voyages, assuming all vessels are of the same type.

• Keep the default settings for the remaining Report Editor sections. Click Display to run the report.