IMOS On-Prem - Creating Custom Expressions in the Report Editor - Examples

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.

You can create custom report columns to display a value based on the values of other columns in the report, or a static value. For example, to add a column to display the value in the Cargo B/L Gross column multiplied by 3:

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. Under Specify custom expression columns, click Add New Column.
4. in the Column Name field, type Cargo B/L Gross multiplied by 3.
5. For Column Type, select Double.
6. Click the Edit button to the right of the Column Expression field.
7. In the Custom Expression Editor, type {Cargo B/L Gross} * 3 and click OK.
8. Under the new Column Name, click Apply and then click Yes. The new custom column is added to the Available Columns list.
9. In the Available Columns list, select Cargo B/L Gross multiplied by 3 and add it to the Report Columns list.
10. Run the report and see that the new custom column values appear.

You could also use a Conditional expression in this case, following Microsoft Expression standards. For example, to display 0 in the custom column if the value in the Cargo B/L Gross column is greater than 30000 and 1 otherwise:
IIF ({Cargo B/L Gross} > 30000, 0, 1)