User`s guide

11.6.6 Using the Highlighting Expert
The Highlighting Expert enables you to apply conditional formatting to all types of report fields (Number,
Currency, String, Boolean, Date, Time, and Date and Time 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.
When used for conditional formatting, the Highlighting Expert allows you to:
• Modify several attributes at once, without writing a formula.
• Highlight all field types used in the report.
• Format font style, background color, font color, and border style.
• Format a field based on its own values or the values of another field.
• Highlight a cross-tab or OLAP cell based on row and column heading values.
• Enter values using your locale-specific number format (such as 1,224.23 for North American users).
• Enter dates numerically or textually (January 12, 2001, or Jan 12, 2001).
• Undo highlighting quickly.
When you need to conditionally format report fields, the Highlighting Expert is quicker and easier to use
than the Formula Workshop. The Highlighting Expert is most commonly used to highlight field values
that are in some way distinguished from other values in the report. You might, for example, highlight
your key customers by printing the {Customer.Last Year's Sales} field with a red background whenever
the sales value exceeds $50,000. Alternatively, to draw attention to outstanding orders, you might bold
the {Product.Product Name} field whenever the {Orders.Shipped} value is False.
The Highlighting Expert, however, is not as flexible as the Formula Workshop. To use the formatting
capabilities of Crystal Reports to their full potential, create your own conditional formatting formulas
with the Formula Workshop (accessible through the Format Editor dialog box). For complete details,
see Using Formulas.
11.6.6.1 Conditionally formatting fields using the Highlighting Expert
The Highlighting Expert is a quick alternative to the Formula Workshop; it allows you to conditionally
format any of your report fields. The Highlighting Expert essentially 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.
2012-03-14260
Formatting