Handling Nulls

[alex35]

I am attempting to create a report using fields from three database tables: MM, MA, and CD tables. The MM table is joined to the MA table by a left outer join and the MA table is connected to the CD table by a left outer join. The fields that are selected on the report include: MM.Matter_ID, CD.JudicialDistrict. The CD.JudicialDistrict field is actually a more descriptive version of the MA.Judicial_District Code field.

There are some records were the MA.Judicial_District Code is null. Unfortunately, these records are not appearing on the report.

I have attempted to alliviate this problem by activating the Convert_Null Field Value to Default option.

How do I get all the records to appear on the report no matter if a MA.Judicial_District Code has been entered or not?

Thanks in Advance,
William

 

[mbarron]

If you try to limit your record selection by any of the fields in the MA or CD tables, Crystal will treat the JOINS as Equal and not Left Outers. Mike
If you're not part of the solution, you're part of the precipitate.