- Think of the rule in plain English first. For example:
There are two parts to the rule: If and Then.
The New Highlight dialog helps you specify the If and Then parts of the rule by breaking them down to more specific parts.
- Specify the If part of the rule by completing the following steps:
- In the first field, specify the first part of the If expression. Using the example rule, this part is order total:
- If the order total values come directly from the selected element, from the drop-down list, choose Value of this data item.
- If the order total values come from another data element, specify the expression that refers to the relevant column binding, which refers to the data-set value or calculated value you want. The following expression is an example:
If you want help constructing the expression, use Expression Builder by choosing the ellipsis (...) button.
- In the second field, specify the second part of the If expression by selecting an option from the list. Using our example rule, this part is Greater than.
- In the third field, specify the third part of the If expression. Using our example rule, this part is a value of 50000, as shown in Figure 7-5.
Figure 7-5 Elements of the If expression in New Highlight
You have now completed the If part of the rule, which specifies:
- Specify the Then part of your rule, which is "then set the font color to blue and the font style to bold," by completing the following steps:
- Choose Color, then select a color from the color picker.
- Choose B to select the Bold format, as shown in Figure 7-6.
Figure 7-6 Elements of the Then expression in New Highlight
Choose OK.
The formatting rule that you created appears in Highlight List, as shown in
Figure 7-7. The rule takes effect the next time that you run the report.
Figure 7-7 Highlight List