The Report Designer, which can be accessed from the Report List by selecting Design in the Report List Action column, enables you to create custom reports. The Report Designer provides a live preview so you can see your edits in real-time. You can apply filters that decrease loading times, group data, create custom columns, add aggregate functions, and perform simple calculations. When you are finished, you can export your report.
Report Designer Modes
The Report Designer has two modes: Design Mode to create the report and Report View Mode to view the report. To switch between Design Mode and Report View Mode at any time, click the Design button:
When clicking on the report row, it will open the Design Mode, but if you click the report title hyperlink it will run the report without access to the Design button.
Design Mode (for reports with Source IMOS only):
To build a report in (only available to report owners and Security Administrators), create or open it from the Report List and then do the following:
Report View Mode:
In either mode:
As with any other list, you can search, change your view, save user views (for reports with Source IMOS, in Report View Mode only), and export.
As with any other details view, you can navigate to a different record by clicking its card or return to the list by clicking its Name.
When opening a report, the default list view displayed is the original dataset of the created report.
The list view you are currently viewing is highlighted and underlined (e.g., LIST VIEW NAME).
Defining Report Properties
To create a custom report in the Report Designer, do the following:
Do one of the following:
To create a new report, on the Report List or card panel, click + and then click New Report.
To copy a report, in its Report List row, click Copy.
On the Report Properties panel, you can do any of the following:
Enter Title, Subtitle, and Description. To Include description in report, select the check box.
Note: It is important to create reports with unique titles (max 64 characters in length). If a new report is created with an already existing name (capitalization will not differentiate the titles), the report cannot be run via Scheduled Tasks.
Select Defer updates: Changes you make to your report appear in real-time. To hold updates until after setting up the report, to improve performance and loading times, select this check box. When selected, click Refresh to see the results of your design.
Select a data Source:
IMOS: Veson IMOS Platform (IMOS) data, shown in the Data Map.
Veslink Forms: Includes data from the Voyage Reporting forms currently in the database.
Select the Access type:
Public: Users with permissions to edit public reports can edit all public reports regardless of report ownership.
Security Groups: For each group, you can assign either Read Only () or Read and Write () rights for this report.
Select the Output type: Each Output type has different options.
CSV, PDF, Word, or XML:
Template: Select an Excel Template from File Management.
Note: Use of the Reporting Database requires a separate license. To set it up, contact Veson Nautical Support.
IMOS User Distribution and Address Book Distribution (for CSV, Excel, PDF, Word, and XML Output types only): Reports can be distributed to Distribution Lists and those Address Book contacts with the Reports check box selected on the Contacts tab. To distribute the report, either select it in the Report List and click the Distribute link or create a Scheduled Task in the Messaging Service. For more information, see the Messaging Service Manual.
To prevent the distribution of empty reports, select the Distribute Only Report With Data check box.
Viewing Tables and Elements
Note: You must have the Data Dictionary Module Right selected under Quick Links in the Data Center.
In the Data Dictionary, you can view all tables and elements (fields) used throughout the Veson IMOS Platform, including custom elements.
Disable Show All Tables
When enabled, there is no option in Report Designer to Show All Tables. Users must create reports starting from the primary tables and may join to other tables from there.
Enable JSON Path Query
When enabled, Report Designer reports have an Optimize query for document export option available. This makes exporting to XML via datashed faster for certain reports. Requires SQL Server 2016 or newer.