Suppress if Records are Not Null 3

[dunkyn]

I have a text field in a group footer and I want to suppress the section if my group number or category name is NOT null.

(I am trying to get a work around to display group names if there are no records to display because I have an equal join and not a left outer join.)

Is there a formula for ISNOTNULL()?

 

[ToastyinVA]

what about Not IsNull

 

[mbarron]

If it were possible, it would be

not(isnull(some.field))

Crystal won't allow you to group on something that isn't there.

Mike

 

[dunkyn]

Thank you both.

And, Mike, I'm glad you understand what I am trying to do.

I have additional footers will fake text headings, but I just can't get the selection statements down so that the headers appear when there are no records for that particular category. Looks like I've hit a deadend.

 

[kenhamady]

I have an article on your options for reporting on data that isn't there. Read it at:

http://www.kenhamady.com/news0208.html

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[dunkyn]

Just what I needed. THANK YOU!!!

 

[JJB81]

I need to suppress a field if the data returned is null.
How can i do this?

 

[Naith]

In your conditional suppression editor (right click your field, select format, and click the X+2 button next to Suppress), enter

IsNull({YourField}) or {YourField} = ''

. Only use the "or {YourField}" part of the formula if your field is a string field.

Naith

 

[synapsevampire]

I responded to your other post.