Print Page | Close Window

Removing decimals

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12486
Printed Date: 01 May 2025 at 2:42pm


Topic: Removing decimals
Posted By: Dane
Subject: Removing decimals
Date 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
 


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

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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window