Defining Conditional Formats in Classic Designer

Conditional formatting controls how values in the report table are displayed based on conditions of the data in the report. For example, you could display values that do not meet a certain minimum threshold in red.

 To define a conditional format rule

1.

In Classic Designer, click on a column header in a report and select Conditional Format from the menu. The Conditional Formatting dialog box opens.

2.

In the Condition text box, enter a logical expression using BQL that returns true or false. For example, to display a quantity value in bold when the value is greater than 5000, enter the condition: [OrderDate:Quantity] > 5000.

3.

Set the font type, size and colors to use when the condition is true. For the example above, you would set the font type to bold.

4.

Click Save. The conditional format rule you just created will be displayed in a second Conditional Formatting dialog box which displays all the conditional format rules for the table.

5.

Click Save in the dialog box. The formatting you selected for your conditional format rule will now be applied to the data in the column that meets the condition.

See Also
Defining Expressions
Expressions Reference
Infor Logical Query Language Functions Reference
Creating a Conditional Display Expression