Conditional highlighting

Top  Previous  Next

This feature of the ”Text” object allows you to color an object depending on a specified condition being met. The condition can be any expression. We’ll use the example with groups to demonstrate this. Let's set order totals greater than 5000 to be colored green. Select the object containing the Group.“ItemsTotal” field and click on the “Highlight” _img147  button in the designer toolbar. In the highlight editor enter a conditional expression which, if exceeded, will highlight the object; also set the font and background attributes for the highlight.

 

clip0182

 

These settings produce this report:

 

_img149

 

Note the conditional expression we used : 'Value > 5000'. Here 'Value' is the value of the DB field to which the object is linked. Alternatively the condition could be set as '<Group."ItemsTotal"> > 5000'. In general, any legal expression may be used.