do not display record

[techpielmorena]

Hi,

I have a report that includes the "phone" field. I would like for the final report to keep records with a blank "phone" field from showing on my list.

What would be a formula to accomplish this?
I'm using 8.5

Thanks in advance.
Jane

 

[dgillz]

Write a record selection formula:

Not Isnull({YourField})

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[GJParker]

It depends on what value is held in the blank fields, are they nulls or blank strings "" ?

dgillz is right , use the record selection formula to filter these records from the report testing for the blank value

either

Not Isnull({YourField})

or

{YourField} <> ""

HTH



Gary Parker
MIS Data Analyst
Manchester, England

 

[Madawc]

Not Isnull({Phone})
and
{Phone} <> ""

If you have nulls, they must be tested for first. Blank could mean either null data or space-filled.

I am assuming that phone number is a string field.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[techpielmorena]

Thank you. It worked!