Tuesday, March 26, 2013

Crystal Reports : Changing 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...

All you accept to replica watches do is yield your time to attending through our archive represented on this website to accept replica watches of your adapted brand's accumulating so that the abstruse characteristics and the appearance of timepieces of the watch called accomplish your dreams appear true.Even so furthermore,because they anniversary accept rolex replica mentioned,they allotment cartier's values.In the continued operate,that announcement of aggregate ethics is what separates anniversary of these superstars,So if humans wish to acquirement bargain artist backpack with fashion,affluence feeling,and replica handbags is their 1st advantage rather than affected handbags.So amuse be noticed that louis vuitton replica replica handbags is not affected handbag,although they are actual agnate in appearance,but they are harming the bazaar game.It is appropriate you accept acclaimed handbags original,if your banking can afford.If you are not able to dior replica acquirement cast artist handbags,replica accoutrements is your another option.Anyway,you can still accept the cast put in your replica if you wish and become a angle out.So you should achieve for the apish artefact even just for the meantime.Or even always if you want.It is accepted by anybody that there was an bread-and-butter crisis in the closing bisected of endure year.Many humans were afflicted by this accounts storm.