Tuesday, July 27, 2010

Crystal Reports : Changing the decimal precision on a field

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.


Jasmine said...

hi,You have a very good blog that the main thing a lot of interesting and useful! payday loans ,thanks

Coco Ada said...

The Rolex Replicas Submariner Swiss Replica has a acclaimed and continued
history. Its aggregate of unparalleled breeding and versatility appealed to
rolex replica James Bond fans.
The Submariner aboriginal went into assembly in 1953 and clearly launched the
Rolex Replicas Submariner at the Basel watch fair. Neither hermes replica models had the
characteristic easily which are now associated with the Rolex watches. They both
had beeline actualization hands, and the actualization of the aboriginal Rolex
Submariner diving watch is believed to be in a antecedent year. Over the
afterward years, Rolex Replicas Submariner has accustomed a lot of louis vuitton replica changes, and
the James Bond films are accustomed with active abounding of those changes.
In the aboriginal years,Rolex Replicas aswell produced a baby amount of the
6200-series Rolex Submariner watches. This was the aboriginal hublot replica Submariner to accomplish use
of the new easily and aswell had an colossal ambagious crown. Within a few
years, Rolex Replicas revised its Submariner line, bearing models with altered
admeasurement crowns. By the aboriginal 60s, there were added models. All of
these aboriginal Rolex Replicas Submariners acclimated either bizarre or gold
press on bright atramentous dials. Altered types of cartier replica acrylic would be
acclimated for the luminated markers. The next accumulation of Submariner
watches, had even added cogent change in their appearance, and the added
accepted Rolex Replicas designs surfaced. A amount of new appearance were
added to the case to accommodate aegis for the movement. The colossal acme
anon became a accepted affection in all Rolex Submariner watches. Sometime in
the aboriginal 1960s, Rolex discontinued the use of radium acrylic for the
beaming indices, switching to the safer Tritium-infused paint. In 1965-1966, Rolex
Replicas discontinued use of gilt/silver bizarre dials on the Submariner watches,
switching to white printing. A final important change came with the addition of
the 1680 archetypal in the backward 1960s.