Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

Join Tek-Tips
*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.

jjoy123123 (Programmer) (OP)
22 Apr 03 23:08
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!
checkai (Programmer)
23 Apr 03 10:43
Do you want the records that contain the NULL value? If not you could type in 'NOT ISNULL({fieldname})' in the record selection.

jjoy123123 (Programmer) (OP)
7 May 03 10:56
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.

lbass (TechnicalUser)
7 May 03 19:18
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.


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!

Back To Forum

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