Friday, October 25, 2013

Crystal Reports : Font Color and Conditions

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:

Viora care said...

Emporio Armani timepieces are generally bigger than almost every other replica handbags uk in the marketplace. It is because regarding several causes nevertheless the principal kinds are usually which it aids folks notify enough time, that offers area regarding roman numerals being extra about the layout with the observe, looked after offers a lot of area for your emblem being set at the top with the time confront with the observe. Any person getting a great Emporio Armani observe will probably be very happy making use of their huge rolex replica sale. Making use of fresh technology, Ingersoll made pants pocket timepieces and also designer watches. The particular "Dollar Watch" : also referred to as "Yankee" has been the initial Ingersoll tag heuer replica, made about computerized creation traces regarding timepieces, and also acquired it really is identify as it has been marketed regarding only 1 money. As a result of awesome accomplishment The particular Yankee acquired, The particular Ingersoll Bros improved creation and also exposed fresh producers to keep upwards rolex replica sale the particular sought after. Inside the yr 1896, Ingersoll's merchandise array extended as a result of several complex landmark refinements as well as the tiniest pants pocket rolex replica ever made is made. Tissot, any Europe observe business, has been proven inside the yr 1853. Charles-FĂ©licien Tissot along with his child Charles-Emile established the inspiration with this well known enterprise inside the metropolis regarding Le Locle.