Finding empty fields

[TMAMJ]

Any tips for finding fields left blank by multible data entry users. Im attempting to do a check off sheet (report to make corrections)that will list entries where fields have been left blank. I have the report setup and can find blank spaces in one field by using isnull, but I'm new to Crystal and I am having trouble setting it to look for empty data in more than one field. As I said I tried isnull and "or" for the different fields. Any suggestions appreciated. Thanks

 

[lbass]

You are using the correct approach. I think you should us your current record selection formula so we can troubleshoot it. In addition to nulls, you might want to check for empty fields, e.g.,:

(
isnull({table.string1}) or
trim({table.string1}) = "" or
isnull({table.number}) or
isnull({table.string2}) or
trim({table.string2}) = ""
) and
{table.date} >= {?Date}

-LB