Don't want to see null fields

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1671058672

March 19, 2008, 01:29 PM

Ginny

Don't want to see null fields

I'm running a report against a file that has the option of entering something in an Other field. I want to print out all of the responses where someone has put something in the other field.

I have tried using the SET NODATA = 0, but then I still see 0 when the value is nul. How do I make it so I dont' see those responses at all?

March 19, 2008, 01:34 PM

Darin Lee

WHERE OTHER_FIELD NE MISSING;

would eliminate all rows where the value of OTHER_FIELD is actually null.

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat

March 19, 2008, 01:38 PM

Ginny

quote:
WHERE OTHER_FIELD NE MISSING;

Perfect that's exactly what I needed.