Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Suppress 0 in line graph

Suppress 0 in line graph

I've set up a line graph in Crystal 8.0.  When the graph encounters a blank record (value is NULL not 0), the graph displays properly as long as I'm running the report within Crystal Report Designer - you don't see a data point for that record.  The line discontinues at this point and then picks back up with the next record that has a valid number in it.   

Here's the problem - I'm calling this same report from VB 6.0.  HOWEVER, the blank record that was not being displayed running from Crystal is now showing as a 0.  So now my line graph dips all the way down to 0 before going to the next valid record.  It's messing up my graph because it appears as if these records have a 0 instead of being NULL.  

Any ideas?  I'm clueless on this one.  I assumed that a Crystal Report graph would display the same regardless of whether it's being called from VB or running with Crystal but it appears that it doesn't.  Thanks in advance!

RE: Suppress 0 in line graph

Do you want the records that contain the NULL value? If not you could type in 'NOT ISNULL({fieldname})' in the record selection.


RE: Suppress 0 in line graph

Well, for that particular graph I want the records that do not contain a null value, but since I have other information I need on that same record, I don't want them excluded.  

For example, in a given record I have Blood Pressure, Weight, and Height.  I have graphs for all 3 of these.  I can't exclude the records with no weight because that same record COULD have a height that I need to see.

RE: Suppress 0 in line graph

Instead of using not isnull{{field}) in your record select, maybe it would work if you just replaced the problem field with a formula and used this for graphing:

if not isnull({field}) then {field}

This would preserve the record, since other fields from that record are being used elsewhere. I'm not sure this will work, but it might be worth a try.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close