>This question has probably been asked many times.
>
>Creating a report after combining two cursors. One of the fields ends up with a lot of null values. (using select with join into cursorname)
>
>What's an efficient way to remove those null values from preview and report? I tried in "print object when" field ! isnull(cursorname.fieldname) That apparently doesn't work though.

That should work, IMO. I don't know why it doesn't.

However, what I usually do is to use the NVL() function.

In the report itself, use the expression:

nvl(CursorName.FieldName, "???") && or spaces, if you don't want to show anything

Or, use a similar expression directly in the commands that SELECT the data:

select ..., nvl(SecondTable.MyField, space(15)) as MyField;
   from FirstTable left join SecondTable on ...;
   into cursor Tmp

The above assumes that MyField has 15 characters - it is important to keep the expression, in a SELECT statement, at a constant length.

>
>Thanks in advance!