IMOS On-Prem - Formatting Column Values in the Report Editor - Example

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.

For a report that displays the value of Cargo B/L Gross with three decimals, center-justifying and setting the color based on values:

• Less than 30000: Green
• Between 30000 and 40000: Yellow
• More than 40000: Red

Follow these steps:

1. Edit or create a legacy report from the IMOS Report List using the General Operations dataset.
2. Add Cargo B/L Gross to the list of Report Columns.
3. Select Cargo B/L Gross in the list of Report Columns.
4. Under Column Properties, enter these values:
   • Format String: ##.### (or any value that conforms to the Microsoft .NET formats standards. See Standard Numeric Format Strings for details.)
   • Justify: Center.
   • Text Color (click Edit to open the Text Color Editor.): IIF({Cargo B/L Gross} < 30000, 'Green', (IIF({Cargo B/L Gross} < 40000, 'Yellow', 'Red')) )
     Note: Either type or use the Column and Color drop-down lists.
5. Click OK.

The conditional expression in this case uses the Microsoft Expression standard.