Thursday, February 27, 2014

Crystal Reports : Changing Decimal Precision

In the case of "calculated" fields, especially where division is involved, the result can sometimes be a number like "10.25" or "13.53".

Crystal will default the formatting of such a result to include the decimal places as the calculation requires.
If you only wish to see the "integer" portion of the field in question, you need only to change the field formatting.

1. Right-click on the field in question
2. Select "Format Field"
3. On the "Common" tab, click "Customize"
4. Drop down the "Decimals" list to select your desired precision.
5. "Ok" your way back out.

Note : These Field Formatting options are only available on numeric fields. If your formula is returning a string, try using the ToNumber() Crystal function to convert it.


Anonymous said...

You can also find several products to allow the fashion alert louis vuitton replica master by using a amazing fashionable pc container that could be dependable together with alluring. Certain computer homeowners have also put to use messenger shopping bags to include your personal pc. Any deep within the messenger container is highly recommended for any computer dior replica handbags personal pc. Any Fendi Messenger/ Computer Designer purse, during blue together with beige colors, get this to an exceedingly beautiful device. The attractive container delivers the designer's business logo over the nylon disguise utilizing bright white synthetic leather fit. There is a good several strategy zilch very best closure, brightness jewelry shade apparatus, together with some sort of fake chanel varying 40 centimeter get across body system bracelet control. Any container is certainly relaxing to include together with attractive. Any container is reached replica handbags during Toscana. Different kinds of single-use bag sacks can get different kinds of harmful environmentally friendly applies to yet fake swiss watches each one is equally as pertaining to. Clear plastic bag sacks happen to be exceptionally very useful together with quite low priced to supply during mass fast they also undertake own your cons.

cheap replica watches said...

Currently with occasion while these excellent knives are actually enjoying your pinnacle linked to success, Karl switched her or his awareness of provde the very ideal wristwatch there exists so their wonderful valuable operate presented birth on the Europe Equipped service timepieces that is currently add up to the recognition linked to his kitchen knives. Eventually, numerous types replica Hublot watches in addition to best replica Patek Philippe watches unique variations appeared integrated on the distinctive type of this kind of popular designer watches. These form of designer designer watches using decent looks like it's along using fantastic productivity made the actual Swiss Equipped service name a group of their own personal. The a pair of blades and also designer designer best fake Louis Vuitton Luggage watches however reveal the exact same famous replica Gucci watches label plus buy knockoff Christian Dior outstanding quality, the certain Swiss Armed service designer designer watches are a number of actions before hand.

Zheng junxai5 said...

coach outlet
rolex watches
concord 11
polo ralph lauren outlet
michael kors outlet clearance
celine handbags
coach outlet online
michael kors outlet clearance
coach factory outlet
air jordan 4
adidas superstar
michael kors outlet online
louis vuitton outlet
michael kors outlet
louboutin shoes
adidas stan smith
longchamp outlet
oakley sunglasses
cheap ray ban sunglasses
tods outlet store
nike roshe one
adidas uk
michael kors outlet clearance
fitflop clearance
kate spade outlet
kobe shoes
north face jackets
insanity workout
kobe 10
ray bans
jordan concords
kobe 8
ladies cartier watches
air jordan homme
oakley sunglasses
ralph lauren sale
louis vuitton outlet
christian louboutin sale
coach factory outlet online
replica rolex watches