Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 30 Apr 2007 at 11:42am
You can use the Int() to trim the decimals or use the Format Field option to not show them.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 02 May 2007 at 12:23am
It is on the Number tab. Since you didn't mention it in your list then I assume that you don't have that tab. If so, then that means that the data is a string data type and you have to convert it to a number. To do that, create a formula and use the ToNumber() function so that it converts the string to a number. Then the Number tab will be available to you and you can format it properly.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum