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

Error rendering macro 'excerpt-include' : No link could be created for 'IMOS'.

 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.

  1. To add a custom expression column, click  .
  2. Enter a Column Name and select a Column Type, the data type of the column to be added. To enter a Column Expression, click .
  3. In the Custom Expression Editor, for each column:
    1. Select a Column from the list and click to insert it into the expression.
    2. Add any functions and values: You can make calculations, concatenate columns, or use an IIF statement.
    3. 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.
    4. Click . The Column Expression appears in the Column Expression field.
  4. After creating the Column Expression, to add it to the list of Available Columns, click .
  5. To add the Column Expression to the list of Report Columns, select it in the list of Available Columns and click .
  6. 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