Welcome to the Veson Nautical Knowledge Base. In the Help Center, you can view the same articles and contact support as needed.
IMOS On-Prem - Custom Expressions
 This is a Key Topic, with high value for all users.
In the Columns section of the Report Editor, you can add a custom column to the report that will display calculated values based on a formula and/or an expression you specify for it. You might use this to combine two columns into one, as in the example below.
Note: For additional information, see the Microsoft expression editor documentation at http://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx.
- To add a custom expression column, click .
- Enter a Column Name and select a Column Type, the data type of the column to be added. To enter a Column Expression, click .
- In the Custom Expression Editor, for each column:
- Select a Column from the list and click to insert it into the expression.
- Add any functions and values: You can make calculations, concatenate columns, or use an IIF statement.
- Use any of the following macros:
- _NOW_: Gives the current date and time of issuing the report.
- _NOW_UTC: Gives the UTC current date and time of issuing the report.
- TODAY: Gives the current date, with time set to 00:00:00.
- Click . The Column Expression appears in the Column Expression field.
- After creating the Column Expression, to add it to the list of Available Columns, click .
- To add the Column Expression to the list of Report Columns, select it in the list of Available Columns and click .
- To change the Text Color, Background Color, or Font Weight for a column to highlight particular data, click . You can even set conditional color or font weight that changes based on the value of the data. In the editor, insert a column and then insert its color or font weight.
Still need help? Visit the Veson Nautical Help Center.
Copyright © 2017-2024 Veson Nautical LLC All Rights Reserved - Privacy Notice | End User Terms of Use