Joined: 14 May 2015
Online Status: Offline
Posts: 8
Topic: zeros and negatives wont display Posted: 10 Jul 2015 at 1:37am
I have a report that has multiple 0 values, but instead of showing the zero, crystal shows a blank space instead. then, 2 columns over i have a field that should subtract another field from that 0 and be negative, but since the zero field is empty, it wont and the sum comes up empty two. Any idea how to fix this?
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 10 Jul 2015 at 4:11am
Are the fields truly 0 or are they "null"? To tell for sure, try this:
Create a formula using the field. Is should look something like this:
If IsNull({MyTable.MyField}) then 0 else {MyTable.MyField})
Use this on your report instead of the field. If it now shows "0", then the field is null. If this is the case, you'll also need to use this formula when you're subtracting in order to get a value to show.
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
IP Logged
