Suppressing Null Series?

[humanageek]

I'm constructing a simple bar chart, which is reporting number of calls for specific teams.

Unfortunately, in the database, there are a number of records in which this particular "team" field is null.

My chart continues to report the "null" series, showing a non-labeled series in the legend, and the bar representing the value.

Of course, I can suppress this in the text, but is there any way to suppress a null value from being grouped and displayed in the chart?

ANY help you can provide would be greatly appreciated!

Thanks!

 

[synapsevampire]

In the record selction formula->Record add a line to eliminate nulls:

isnull({table.field})

-k

 

[humanageek]

I tried your solution long before posting. In my version of CR9, I placed in the record selection formula the following:

And Not ({CL_CALL_LOGGING.IACUSTOM_STRINGDROPDOWN5})

I also tried isnull({CL_CALL_LOGGING.IACUSTOM_STRINGDROPDOWN5}),
also
isnotnull({CL_CALL_LOGGING.IACUSTOM_STRINGDROPDOWN5})

and everything else I can think of.

 

[synapsevampire]

You can verify what is being passed to the database, and I would have been able to further assist you had you in this post placed what I mentioned you neglected in the first, the Crystal version and database/connectivity used.

You probably need:
(
not(isnull({CL_CALL_LOGGING.IACUSTOM_STRINGDROPDOWN5})
)
and
(
not(trim({CL_CALL_LOGGING.IACUSTOM_STRINGDROPDOWN5}) = "")
)


-k