Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
|
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 24th, 2007, 10:20 PM
Authorized User
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default Rounding Numbers and Displaying Decimals

Hi,

 I have a column in my CR that displays numbers with decimal. I want the numbers to be displayed as it is or with 2 decimals. Example : 3.6532 must be displayed as 3.6532 or 3.65

Is there a way to display number at it is or to round off only the decimals? I tried using custom format and round off the number to hundredth or even thousandth, but it doesnt work. CR still rounds off the numbers in Unit and displays decimal as 0, as in 3.6532 is displayed as 4.00. I hope you have an idea to solve this and this is not a bug of CR in VS2003. Thanks!

 
Old April 25th, 2007, 09:12 AM
Registered User
 
Join Date: Apr 2007
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It sounds like it's being rounded before it gets to your report.
I created a report in CR in VS2003 and put 3.6532 in a formula field. With out even touching the formatting it defaulted to 3.65.

 
Old May 8th, 2007, 10:56 AM
Authorized User
 
Join Date: Dec 2004
Posts: 80
Thanks: 0
Thanked 0 Times in 0 Posts
Default

select the field , right click it and select format field and under number tab select the rounding options and display decimal option that u want according to your need





Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying Numbers on Applet mirqadir Java Databases 1 July 24th, 2008 06:38 AM
Rounding Numbers ricespn Beginning VB 6 5 November 6th, 2006 05:24 PM
more decimals fskilnik Dreamweaver (all versions) 2 September 29th, 2005 07:05 AM
Displaying decimals in C# alfonz ASP.NET 1.0 and 1.1 Basics 3 September 20th, 2004 01:51 PM
Rounding Numbers ashley_y VB How-To 2 February 3rd, 2004 06:06 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.