...
- Edit or create a legacy report from the IMOS Report List using the General Operations dataset.
- Add Cargo B/L Gross to the list of Report Columns.
- Select Cargo B/L Gross in the list of Report Columns.
- 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.
- Click OK.
...