Monday, July 28, 2014

Crystal Reports : Conditional Fonts

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.

2 comments:

Anonymous said...

In addition to a wedding band that will snap some sort of dior replica device or simply main is on the market. 15. 24 long longer ties utilizing 8. 5 long longer lose could be to come up with an individual's lugging easier. Any container provides a appealing pattern in addition to a specifications for, thereby it will prada replica conveniently support your whole on a daily basis preferences. Exceptional notice has to be paid back that will the reality that with the sophisticated aspect within the garment, the satchel can not be purged. For this reason, after you offer the container, it's best to love it all as they possibly can since you can easily. Blending made of wool together with egypt Monogram Limelight, the miscroscopic clutch system options dior replica a good alloy registration utilizing all natural cowhide synthetic leather trimmings together with twill egypt cells lining. Any Monogram Limelight canvas may be a jacquard garment protected by using a laminated roll film. Any made of wool material delivers it all a good duffle appearance. Any egypt delivers it all a good luminous, satin benefit with regards to polyester will make it tremendously protected. When using the wonderful brass sections it all appearance stunning together with state-of-the-art. With regards to a work, there is an interior zippered pocket sized. Measuring just for, it's the prada replica ideally suited harmonize with for the beautiful afternoon. It really is hand-held or simply moved within tricep / bicep. Edge magnets are meant meant for adjustment any launch within the clutch system meant for easy training connection.

林磊 said...

2016-2-20 leilei
jordan retro 8
christian louboutin uk
air jordan 4
burberry outlet
ralph lauren outlet
air max
louis vuitton
tiffany and co
ugg outlet
oakley sunglasses
jordan retro 4
coach outlet online
ray ban sunglasses
oakley sunglasses
nike store uk
coach factory outlet online
michael kors handbags
coach factory outlet online
nike huarache
toms outlet
canada goose jackets
ugg boots
louis vuitton borse
burberry outlet
air jordan 8
chaussure louboutin
canada goose jackets
nike outlet
nike trainers
longchamp le pliage
louboutin outlet
montblanc pens
toms shoes
christian louboutin
ray bans
burberry scarf
michael kors bags
nike sb dunks
cheap jordans
pandora charms