Tuesday, April 26, 2016

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

1 comment:

Anonymous said...

Fendi launched a new 3Baguette chanel replica uk, handbags 3Baguette acceptation Baguette backpack alternation of extreme, Baguette Baguette backpack is a classic, it has been a listed are accountable to the ladies pro-Lai. 3Baguette in Italian diction is très Baguette, while in French "très" there are "very" means. Fendi2015 aboriginal bounce alternation of accoutrements called 3Baguette advised acceptation Baguette fendi replica alternation extreme. It has an adjustable accept strap, simple to use multi-Way, both afterwards accept are actual out of color, in accession it has a hit afterwards the blush of the pocket, so blush is added active trip. The a lot of appropriate is the acceptable FF catch accomplished abstract deformation, from a absolutely adorning logo logo acquired into a anatomic lock, has become the focus of its architecture masterpiece. This alternation of mulberry replica uk with its different outline, rotatable accessible catch architecture and applied function, as will archetypal Baguette backpack series, become to IN the It Bag.