Profile

Wednesday 1 June 2011

Crystal Report: highlight report data with color.

Crystal Report can direct connect to most of database servers in market, retrieving data then generate reports.

When data is on a report you might want to highlight them for easy reading. One way to do so is apply a condition of font color.

Here is a sample report with a list of sales performance figures. Let's apply a condition: when a unit sales figure is less than 4000 sales figure will displayed as red. Otherwise will be green. 

From the Crystal Report Design window, go to the Front Property of the Quantity Sold field. then insert a string like this:


After that, save the property and close. Switch Crystal Report from Design to Preview mode. The Quantity Sold data is highlighted as the condition specified. 



No comments: