Hi,
I am using SET NODATA='-' to display a dash when I get NULLs in my resultset for my report. The dash gets displayed for rows when I don't have any formatting on the field AMOUNTS
but when I define the field as AMOUNTS/P18CB the dash no longer gets displayed.

I thought I could define a field and use the if
to make the formattign conditional but I can't get it to compile.

DEFINE FILE FLASH
DS_NAV_VALUE/P18.2 = IF NAV_VALUE EQ MISSING THEN NAV_VALUE ELSE NAV_VALUE/P18.2CB;
END

Another problem I have is that I have a subtotal which displays the sum of AMOUNTS. When all the values are NULL and just a dash is displayed the subtotal line still displays ".00". I would like the subtotal to display a dash also.


Thanks in advance.

Mairead,

Use the MISSING attribute within your DEFINE -

DEFINE FILE FLASH
DS_NAV_VALUE/P18.2 MISSING ON = IF NAV_VALUE EQ MISSING THEN NAV_VALUE ELSE NAV_VALUE;
END