Learn how to a build a cloud-first strategyRegister Now


Color coding in Crystal

Posted on 2006-04-20
Medium Priority
Last Modified: 2012-08-13
Do you know if there is a way you can either bold or color the fields if certain condition met in Crystal Reports? I have version 8.5

Question by:sgaurav7
LVL 26

Accepted Solution

Kurt Reinhardt earned 1000 total points
ID: 16504495
Crystal 8.5 allows you to use the Highlighting Expert against Numeric or Currency fields.  Simply right-click a field or formula and select 'Highlighting Expert'.  Alternately, you can conditionally change the color and style of the font or background of any field  by right-clicking a field and selecting 'Font' or 'Borders and Colors...'.

When you create a formula to conditionally change the appearance of the field, your formula must be a boolean.  That is, there has to be a true and a false value.  For example, here is the syntax for coloring a field when a condition in one of my reports has been met:

IIF({table.pastdue} = 'Y',Red,Black)

LVL 42

Assisted Solution

frodoman earned 1000 total points
ID: 16507662
You can also apply the same technique to a section using the Section Expert.  This can be useful, for example, if you want to color the entire row yellow if some condition is met instead of coloring one or more individual fields.

LVL 101

Expert Comment

ID: 16517107
2 good suggestions


Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question