Rows Coloring in Crystal Reports

Introduction

During development there are chances that a person might encounter a problem of how to display colored rows in a crystal report, where colors themselves might actually represent something. I encountered this problem and was searching for solutions on the web but couldn’t find any. But in the end I cracked it, so I thought why not share it, so here goes.

Details

Shown above is an extraction from the report I was creating. To achieve such functionality you’d have to open the Section Expert from the Details Section. Then select the Color tab and then click on the formula button.

This would open the Formula Editor where you can specify the different conditions on to which the appropriate colors can be displayed. For more details on the available colors expand the Functions tree item in the Functions Tree, and look for the Color Constants tree item. Expanding it would reveal the list of supported colors.

The formula that I have used here is as follows:

if({AgingList.Total}>({AgingList.Principal}+{AgingList.Profit})) then Crgreen
else if({AgingList.Total}=0) then Crblue
else if({AgingList.Total}<({AgingList.Principal}+{AgingList.Profit})) then CrYellow
else NoColor

(Note: Don’t forget to assign the NoColor color to the rows which do not fit to the requirements for the coloured lines else they may defaultly be displayed as blacked out.)

Save the report and Play. If all conditions satisfied you should be able to see the desired result.