Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: zeros and negatives wont display Post Reply Post New Topic
Author Message
shatcher94
Newbie
Newbie
Avatar

Joined: 14 May 2015
Online Status: Offline
Posts: 8
Quote shatcher94 Replybullet 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?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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.

-Dell
IP IP Logged
shatcher94
Newbie
Newbie
Avatar

Joined: 14 May 2015
Online Status: Offline
Posts: 8
Quote shatcher94 Replybullet Posted: 10 Jul 2015 at 4:13am
that worked, null was the issue
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.