Only Needing Null Fields for a Report!!

[fort]

I am using Windows 2000 and Crystal Reports 8. I am trying to get a report from Crystal Reports pulling up information that doesn't have a null field. I have tried a few different things, one was using the Record Selection-- but I couldn't get it to work, maybe I was inserting something wrong. I am new at this and didn't know if I could use something from the VB side or if I could do it in Crystal Reports. I am sure its something pretty simple, but I can't figure it out.

Thanks!!!

 

[dgillz]

In your record selection formula use this:

Not Isnull({Field}) Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[IanStrange]

I have found that making a supressed formula that shows a one if null something like :

if isnull({field}) then 1 else 0

and then in the formula bit under the supress formula
do :

if {invisible field} is 1 then true else false

hope this helps if not reply and I will see if I can help any more.

 

[fort]

I tried both of your tips and I still can't get it to work. Would you please go into a little more detail(I must be dense). I am using this on a {Inventory.field}. Thanks to both of you!!

 

[rebel11409]

Somewhere in the Crystal Documentation it tells you that Crystal exits anytime a selection or formula encouters a NULL value.

My normal solution is to create a formula using the isnull function to insert a value into any null field.

Then set your record selection, or another formula to evaluate your criteria.

 

[fort]

I got it to work!!! Thanks so much to all of you!!!