I am creating a Define field as a P9.3 and by default the value of an empty field displays as .000. I want it to be null/blank. Any thoughts on how I can achieve this?This message has been edited. Last edited by: Trudy,
WF8 Windows
October 23, 2018, 03:26 PM
pav
Try this.
SET NODATA=''
DEFINE FILE CAR
TEST/P9.3 MISSING ON=IF SALES EQ '' THEN MISSING ELSE SALES;
END
TABLE FILE CAR
PRINT
TEST
*
END
-RUN
October 23, 2018, 03:56 PM
Waz
Or use zero suppress.
Field/P9.3S = MyField ;
Very much depends on what you are doing with the report.
If the format is some sort of export like CSV or Excel, and you want the "blank" then use MISSING, but if its a formatted output like HTML or PDF, then this should work for you.