
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
What are the upsides of contracting skilled web optimization organizations? Expert search marketing companies utilize teams of experts focused on elevating your site's content for browsing engines. This encompasses researchingsearch phrases, adjusting on site characteristics, and managing off-domain enhancements. Moreover, these firms monitor adjustment in from Google parameters and refresh the text on your website as needed. This saves both you your time and your workers from unwanted a
Securing the security of your home is essential in today's unsettled times. Among the best ways to safeguard your belongings and peace of mind is by committing in a trustworthy safe. Regardless of whether you're securing money, important documents, or precious heirlooms, a safe gives a protected repository solution. Regarding selecting the right safe for your house, there are several elements to consider. Above all, assess your safety requirements. Determine what items you plan to store in
Arranging an open-air wedding in Phenix and anxious about the unpredictable weather? Don't let Mother Nature rain on your parade – truly! At [Event Rentals Phoenix], we provide stunning wedding tent rentals that will ensure your distinctive day goes off without an hitch. Our wedding tent rentals are created to supply both charm and functionality. Say "I do" under tha elegant canopy of one of our tents, surrounded by your loved ones and tha breathtaking scenery of Pheonix. With one assortmen
In both personal and professional situations, encountering issues is unavoidable. However, mastering productive trouble-shooting techniques is key for triumphing over hurdles and accomplishing success. In this piece, we delve into the strategies and methods for efficiently addressing dilemmas. From analytical thinking to creative brainstorming, we look into various approaches that can help individuals tackle challenges with certainty and accuracy. Effective challenge solving begins wit
Hello, im noob :)