>I finally figured out how to do a left outer join but in the fields with no match I have .NULL. showing in my report column. There must be a simple way to remove it but I haven't worked with nulls before.

In your report expression, how about something like:

NVL(MyFIeld, '')