HI,

I am trying to display '--' value when i encounter a null value.But in my report i use subheads to print column names and their values as well.Hence if i use SET NODATA = '--' it does not work.

Appreciate your help.

Thanks!

This message has been edited. Last edited by: Kerry,

I'm not quite sure of the relationship you're trying to make. The NODATA value doesn't have anything to do with printing column names using subhead. Can you give us an example of what you're tyring to do and the error you're getting?

Jan,

There shouldn't be any problem. See example:

  
-* File jan1_1.fex
SET NODATA='--'
DEFINE FILE CAR
JAN/I6 MISSING ON = IF SALES EQ 0 THEN MISSING ELSE SALES;
END
TABLE FILE CAR

BY COUNTRY NOPRINT BY CAR NOPRINT BY BODYTYPE NOPRINT
ON BODYTYPE SUBHEAD
"COUNTRY<+0>CAR<+0>BODYTYPE<+0>JAN"
"<COUNTRY<CAR<BODYTYPE<JAN"
" "
ON TABLE SET STYLE *
TYPE=SUBHEAD, HEADALIGN=BODY, $
ENDSTYLE
END

Working example:

SET NODATA='--'

TABLE FILE TRAINING
PRINT
*
HEADING
"WEBFOCUS REPORT"
"GRADE: <GRADE"
END

TRAINING is a demo file usually provided with the software installation (though it may be a leftover from an old version of WF). It is the only demo file I can find that has missing data.

If a column with no data is embedded in a HEADER or is in a report row, it displays the NODATA value, so perhaps we don't understand your question.

Hi,

Am sorry for not giving an example .Taking the EMployee file as an example, the bank_name does not have data for some of the empid's.Although i have used SET NODATA='--' it does not appear.

AM i doing something wrong here ?

Please see the below code:

-* File nodata.fex
-* File jan1_1.fex



SET NODATA='--'
SET ALL=0N

TABLE FILE EMPLOYEE
BY EMP_ID NOPRINT
ON EMP_ID SUBHEAD
"EMPLOYEE<+0>FIRSTNAME<+0>LASTNAME<+0>BANK_NAME"
"<EMP_ID<+0><FIRST_NAME<+0><LAST_NAME<+0><BANK_NAME"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=SUBHEAD, LINE=1,ITEM=1, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1, $
TYPE=SUBHEAD, LINE=2,ITEM=1, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=1,ITEM=2, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1, $
TYPE=SUBHEAD, LINE=2,ITEM=2, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1, $

TYPE=SUBHEAD, LINE=1,ITEM=3, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=2,ITEM=3, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1, $
TYPE=SUBHEAD, LINE=1,ITEM=4, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=2,ITEM=4, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$

TYPE=SUBHEAD, LINE=1,ITEM=5, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=3,ITEM=5, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$

TYPE=SUBHEAD, LINE=1,ITEM=5, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=3,ITEM=5, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$

TYPE=SUBHEAD, LINE=1,ITEM=6, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=3,ITEM=6, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$

TYPE=SUBHEAD, LINE=2,ITEM=1, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=4,ITEM=1, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$

ENDSTYLE
END



  

Appreciate your help

Thanks!

This message has been edited. Last edited by: Jan1,

Jan,
The EMPLOYE file could be a good example for this, but not with the field that you used.
In the following code the display of your '--' in the subhead for missing values is shown:

SET NODATA='--'
SET ALL=ON

TABLE FILE EMPLOYEE
BY EMP_ID NOPRINT
ON EMP_ID SUBHEAD
"EMPLOYEE<+0>FIRSTNAME<+0>LASTNAME<+0>COURSE_CODE"
"<EMP_ID<FIRST_NAME<LAST_NAME<COURSE_CODE>"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=SUBHEAD, LINE=1,ITEM=1, OBJECT=TEXT,  WIDTH=1.25, JUSTIFY=LEFT,WRAP=1.25, $
TYPE=SUBHEAD, LINE=2,ITEM=1, OBJECT=FIELD, WIDTH=1.25, JUSTIFY=LEFT,WRAP=1.25, $
TYPE=SUBHEAD, LINE=1,ITEM=2, OBJECT=TEXT,  WIDTH=1.25, JUSTIFY=LEFT,WRAP=1.25, $
TYPE=SUBHEAD, LINE=2,ITEM=2, OBJECT=FIELD, WIDTH=1.25, JUSTIFY=LEFT,WRAP=1.25, $

TYPE=SUBHEAD, LINE=1,ITEM=3, OBJECT=TEXT,  WIDTH=1.25, JUSTIFY=LEFT,WRAP=1.25, $
TYPE=SUBHEAD, LINE=2,ITEM=3, OBJECT=FIELD, WIDTH=1.25, JUSTIFY=LEFT,WRAP=1.25, $
TYPE=SUBHEAD, LINE=1,ITEM=4, OBJECT=TEXT,  WIDTH=1.25, JUSTIFY=LEFT,WRAP=1.25, $
TYPE=SUBHEAD, LINE=2,ITEM=4, OBJECT=FIELD, WIDTH=1.25, JUSTIFY=LEFT,WRAP=1.25, $
ENDSTYLE
END

You will notice a few differences.
First of all you have to SET ALL = ON for missing values to show in this case.
Then, using BANK_NAME will never show missing values, since the segment the field is in is a unique segment. In (web)focus these segments are treated as always being available, so you'll have to find a real missing field.
Which is the course_code. This shows the '--' in the subheading.

Hope this helps ...

Remember that blank does not mean missing. If the data value is blank, then a value does exists but it is filled with blanks. That is not the same thing as a missing or null value. If the value were truly missing, you would see a dot (.) in the absence of a SET NODATA=statement. Francis and Danny have given you examples. Here's another. In this case I have joined EMPLOYEE to EDUCFILE. Every employee has not attended an education course so they would truly have NO records (missing) in the course file. The SET ALL=PASS forces a left outer join. Otherwise, you would only get employees who have corresponding records in educfile (Inner Join).

SET NODATA=--
SET ALL=PASS
JOIN EMP_ID IN EMPLOYEE TO ALL EMP_ID IN EDUCFILE AS J1
TABLE FILE EMPLOYEE
PRINT EMP_ID COURSE_CODE COURSE_NAME
BY EMP_ID NOPRINT
ON EMP_ID SUBHEAD
"EMPID=<EMP_ID COURSE_CODE=<COURSE_CODE"
END

ok!!

Thanks for the reply!

To expand on Darin's post

Data is only MISSING if the Master file contains MISSING=ON on the particular column
and the column contains a NULL
(this must be there when the data is loaded it cannot be added afterwards.)

Alternatively you can DEFINE the value as missing at run time.

DEFINE  FILE EMPLOYEE
XX/A20 MISSING ON= IF BANK_NAME EQ ' ' THEN MISSING ELSE BANK_NAME;
END
TABLE FILE EMPLOYEE
BY EMP_ID NOPRINT
ON EMP_ID SUBHEAD
"EMPLOYEE<+0>FIRSTNAME<+0>LASTNAME<+0>BANK_NAME"
"<EMP_ID<+0><FIRST_NAME<+0><LAST_NAME<+0><XX"