Monday, September 30, 2013

Crystal Reports : Conditional Font Color

You can specify the color of any font in your report to change based upon a "condition".
A typical example would include making a sales total field "red" if it drops below a certain value.

Let's assume our Sales Total field is called "SalesTotal".

Step #1 : Right-click on the field in question and select Format Field.

Step #2 : Click on the "Font" tab.

Step #3 : Click on the "x-2" (formula) button next to Color.

Step #4 : Use the following fomula: if SalesTotal < 100 then crMaroon else crBlack

This formula forces the sales total to be drawn in red if it drops below 100, oherwise it stays black.

Pro Tip: When testing a condition to change the font, any fields on the report are available to use.

1 comment:

Anonymous said...

You can find different varieties of substance useful for that, in order to omega replica select the a single you want the most effective. Foof couch can be utilized everywhere whether it's regarding properties, places of work, nursing homes, or perhaps regarding libraries. They could be put everywhere point out inside back garden, inside entrance hall, inside cabins or perhaps inside pulling bedrooms or perhaps inside the your bed bedrooms. They may be rolex replica accessible together with almost all shades and also layout which usually will not distract the internal. They will constantly offer a special check out your house. They may be very progressive along with your interior decor. Styles & Measurements: Considering the particular ease and comfort with the foofchair, everyone desires to spot any couch inside rolex replica diverse 4 corners of these residence. They will can be purchased in pursuing measurements XXL dimensions, XL dimensions, huge dimensions and also X-small chair. You should buy foof chair in lots of styles just like mango, banana, fruit, different varieties of basketball or perhaps pencils. They may be also employed when it comes to the particular tag heuer replica uk slumbering. Concurrently, multiple particular person can easily lay on any foof couch. Right or perhaps spherical tiny needles are also available in diverse programs, thus observe the guidelines to the distinct depth at the same time. Almost all tiny needles provide an U . s . dimensions and also omega replica uk any metric comparable. As an example, any dimensions US ALL 8 will be 5mm or perhaps BRITISH 6. Move number.