Page Comparison

...

For details and examples, see Report Designer Data Types and Expressions.pdf and IMOS - Sample Custom Expressions.

...

1. To format a column, open the Properties pane:
   • For a custom column, follow the steps above.
   • For an existing column, click it in the Columns pane.
2. Edit any of the following fields:
   • Bold, Italics:
     1. Click in the field; the formula editor appears.
     2. Type one of the following:
        • "Y"
        • "N" 
     3. Either click outside the box or press Enter.
   • Font:
     1. Click in the field; the formula editor appears.
     2. Select a value from the Font list at the bottom of the box.
     3. Click in the box.
     4. Either click outside the box or press Enter.
   • Font Color, Field Background:
     1. Click in the field; the formula editor appears.
     2. Select a value from the Color list at the bottom of the box.
     3. Click in the box.
     4. Either click outside the box or press Enter.
   • Alignment, Width, Sort:
     1. To change the default value, click to select it, then press Delete.
     2. Select a different value from the list.
   • Header Group: Group consecutive columns together under a single heading.
     
     • For each field to be grouped together, select the field in the Columns pane and add the same Header Group name.
   • Eval. After Filters: Y = Calculate the value for a column with a formula only after filters have been applied.
     Example:
     • Load Port Days is a custom column that will be populated from the Port Days column.
     • Port Function is filtered on Load.
     • Load Port Days column has Eval. After Filters enabled.
     • IMOS will apply the filter before calculating the value of the Load Port Days column.
   • Hidden: Y = This column will be hidden in the report output.
   • Hide if Empty: Y = If there are no values, this column will be hidden in the report output.
   • Is Multi-Line: Y = When the column's width is not sufficient to display the text in the column, it will wrap onto multiple lines.
   • Format: Enter the number or datetime format pattern. For examples on how these patterns work, see IMOS - Formatting Codes for Numbers and Dates.