Crystal Reports  

Highlighting Expert

The Highlighting Expert enables you to apply conditional formatting to all types of report fields (Number, Currency, String, Boolean, Date, Time, and DateTime fields). With the expert, you format the selected field either by specifying a condition based on that field's value, or by specifying a condition based on the value of a different report field. In other words, the expert enables you create the following formula: If the value of field X meets condition A, then apply the specified formatting to the field selected on the report.

This dialog box appears when you right-click a currency or number field object and select Highlighting Expert from the shortcut menu.

Item list

The Item list displays the highlighting formulas created for the currently selected field.

Priority
Use the Priority buttons in the Item List of the Highlighting Expert to set the priorities for your formulas.
New
Use the New button to add a new highlighting formula. After you click New, specify the formula's values in the Item editor.
Remove
Use the Remove button to discard unwanted highlighting formulas for the currently selected field.

Item Editor

The Item editor allows you to set the formula. The Item editor includes a Sample view to demonstrate the formatting specifications applied.

Value of
Use the first drop-down list to choose the field the highlighting rule should apply to.

Use the second drop-down list to specify the condition. The default is "is equal to".

Use the third drop-down list to enter the currency value or numeric value to which you want to apply highlighting conditions.

Font style
Use this list to select a font style for the number or currency value to which you want to apply a highlighting condition.
Font color
Use this list to select a font color for the number or currency value to which you want to apply a highlighting condition.
Background
Use this list to select a background color for the number or currency value to which you want to apply a highlighting condition.
Border
Use this list to select a border style for the number or currency value to which you want to apply a highlighting condition.
Sample
Shows a sample using the settings selected in the Highlighting Expert.

See Also

Conditional Formatting | Format Editor Dialog Box