Color coding in Crystal

Posted on 2006-04-20
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

    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

    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 100

    Expert Comment

    2 good suggestions


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    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. …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now