Monday, December 1, 2014

Crystal Reports : Decimal Precision and You

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...

Giorgio hublot replica sale enhance informal clothes in addition to customized fits completely nicely. There isn't any additional make of the belt which fake rolx for sale the amount of style as well as elegance supplied by this kind of belt. It doesn't matter how the belt is perfect for women or men because it offers outstanding levels of comfort and ease. The actual longines replica may improve your own clothing as well as utes therefore there isn't any cause why you need to skip this. Go with this particular fake panerai treatment a couple of months before the wedding ceremony the ones are certain to end up being amazed while you stroll lower the actual section revealing your own heavy, glossy as well as gleaming fake breitling watches. The cost is extremely appealing as well as if you require it, just about all that you can do is actually use the internet as well as location your own purchase.