Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: decimal Post Reply Post New Topic
Author Message
shamee_banu
Newbie
Newbie


Joined: 15 Mar 2007
Location: Solomon Islands
Online Status: Offline
Posts: 28
Quote shamee_banu Replybullet Topic: decimal
    Posted: 30 Apr 2007 at 1:58am

hi,

i have t his part id number

51106.40,53329.59,8374.23......and so on

my problem is.... i don`t want the decimal number i should be

51106,  53329, 8374....

 
how shall i do this can any one help me....
 
thanks
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
shamee_banu
Newbie
Newbie


Joined: 15 Mar 2007
Location: Solomon Islands
Online Status: Offline
Posts: 28
Quote shamee_banu Replybullet Posted: 01 May 2007 at 7:56pm

which tab am i suppose to use the  common, broder ,paragraph in the format editor  to not to show the decimal point

plz guide me...
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.063 seconds.