Null values in a field

[Former Member]

I have a built report that I would like to change to show null values in a certain field. Is there an easy way to do this within crystal that I'm missing? Thanks in advance for any help

[DellSC]

How are the null values being excluded now?  Are you joining or filtering on the field that might be null?

If you're joining on the field, you'll need to right-click on the join in the Database Expert, select "Link Options" and do one of the following:

- If you're joining from the field to another table, make the join a right-outer join.

- If you're joining to the field from another table, make the join a left-outer join.

If you're filtering on the field in the Select Expert, you'll need to edit the selection formula and do something like this:

(

IsNull({MyTable.MyField}) or

{MyTable.MyField} = 'blah'

)

Note where I've used the parentheses - if you have any other selection criteria you MUST include them for this to work correctly.

-Dell