Hi,
I am trying to generate a report in EXL07 fomat in WebFOCUS version 8.1.04.
The report contains date field say A.
In the report the field A displays '00/01/1900' in the formula bar where the data is missing in db, while in actual cell it displays blank(as expected).
Please suggest on following:
1. is this the expected behaviour in WF8.
2. how can we suppress the value in formula bar to display blank.

The code example is as below:
SET NODATA = ''
TABLE FILE XYZ
PRINT DATE_FIELD
ON TABLE PCHOLD FORMAT EXL07
END

Please suggest.

Thanks,
Vivek

This message has been edited. Last edited by: <Kathryn Henning>,

Perhaps you can try something like this:

TABLE FILE CAR
SUM
SALES
COMPUTE DT1_NULL/YYMD MISSING ON = IF COUNTRY EQ 'ITALY' THEN '2015/05/25' ELSE MISSING;
COMPUTE DT1_STRING/A8YYMD = DT1_NULL;
COMPUTE DT1_BLANK/YYMD = IF COUNTRY EQ 'ITALY' THEN '2015/05/25' ELSE '';
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL07
END

COMPUTE DT1_STRING/A8YYMD = DT1_NULL; seems to work - it displays blank in the formula bar of Excel 2007.

This issue does not occur in EXL2K which is one more reason I'm not ready to try these esoteric versions of Excel formats.

Add SET NODATA = '' to the top of Francis' code and the first date column "behaves" as well.

T

Thanks Francis and Tony.
The resolution works perfectly in the adhoc reports.
How do I over come the issue in case of self service report, where field is picked directly from the master file.

Vivek