>>Hi all,
>> 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.
>>
>>
>>Many thanks in advance to all the helpfull people at this site.
>
>John, you can put
>NOT ISNULL(myfield)
>into Print When condition for the report field.
Or you can use nvl function in your SQL.
If it's not broken, fix it until it is.
My Blog