Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: When Zero is not Zero? Post Reply Post New Topic
Author Message
COLE22631
Newbie
Newbie
Avatar

Joined: 14 Apr 2011
Online Status: Offline
Posts: 1
Quote COLE22631 Replybullet Topic: When Zero is not Zero?
     Posted: 14 Apr 2011 at 4:43am
Hi
 
I've come across a problem generating a report on an Access database:-
 
When the two same whole numbers are deleted from each other Crystal doesn't think that it is 0 
 
I have checked the database tables and only whole numbers are dispalyed.
 
I have tried displaying 10 decimal places 0.0000000000 and it still thinks it isn't zero
 
The only way to resolve is to round to 0 decimals round({field},0)
 
Why doesn't Crystal think 10 - 10 = 0
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 15 Apr 2011 at 3:33am
did you check what CR sees or what Access sees?
 
If you know that the values are whole numbers, you can use FIX(), which will truncate the decimal part of the number.
 
I realize that it is an extra step, but it would appear that CR doesn't see the values as whole numbers, but as fractional, and as such isn't equating them.
 
HTH
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.