| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
...
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:
- On the IMOS menu, click Reports.
- Click New, then click Report (Legacy).
Basic Information
- Type a Title and Description for the report.
- 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.
- 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.
...