Tips and Tricks
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Tips and Tricks
Message Icon Topic: Removing decimals Post Reply Post New Topic
Author Message
Dane
Newbie
Newbie


Joined: 03 Mar 2011
Location: United States
Online Status: Offline
Posts: 1
Quote Dane Replybullet Topic: Removing decimals
    Posted: 03 Mar 2011 at 4:27am
Hi all,
 
I need to remove the decimal from a currency field and still show the 2 digits after the decimal.
 
I need   250.00  to show as 25000.
 
Any ideas?
 
Thanks
 
IP IP Logged
gyswamy
Newbie
Newbie
Avatar

Joined: 03 Mar 2011
Location: India
Online Status: Offline
Posts: 13
Quote gyswamy Replybullet Posted: 03 Mar 2011 at 8:59pm
Hi,

Select the filed which you want to show as decimal - Right Click on it - select format object - Select Number Tab on top and select style as 'custom style' and then click on Customize which opens one pop up window - in that click on Number tab on top - you can find one Decimals with Drop Down list - in this you can select how many decimal you want to display for selected field...

This solution not suitable please ignore it.

Swamy
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 04 Mar 2011 at 4:03am
The problem with just using the field format is that it will strip off the decimal values which you want to display.  Instead, create a formula that will multiply your field by 100.  Put the formula on the report instead of the field and format to not show any decimals.
 
-Dell
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.031 seconds.