• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1199
  • Last Modified:

Crystal report line chart with null value.

I have a table with the data:

ID   Value
1      34
2      33
3      null
4      null
5      56

How can I display it with crystal report? I don't want to use isnull(Value, 0) from SQL, and want to hide the line when value is null.

0
JameMeck
Asked:
JameMeck
1 Solution
 
mlmccCommented:
You can use the select exp3ert to not select those lines
Not IsNull({ValueField})

You can suppress the section with
IsNull({ValueField})

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now