Print Page | Close Window

decimal

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=608
Printed Date: 02 May 2024 at 3:31pm


Topic: decimal
Posted By: shamee_banu
Subject: decimal
Date 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


Replies:
Posted By: BrianBischof
Date 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>

Posted By: shamee_banu
Date 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...

Posted By: BrianBischof
Date 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>


Print Page | Close Window