Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [WORKED AROUND] Set numeric values to Null and hide column
Go
New
Search
Notify
Tools
Reply
  
[WORKED AROUND] Set numeric values to Null and hide column
 Login/Join
 
Master
posted
I followed the tips here:

http://forums.informationbuild...791069081#3791069081

and then SET HIDENULLACRS=ON

but the column (and title) with the null values still shows up.

Any suggestions?

This message has been edited. Last edited by: George Patton,


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Reply With QuoteReport This Post
Guru
posted Hide Post
Hi George-
This may be a brute force approach but in the past, I have examined each column for a non-zero, non-null value and set a flag via a DEFINE, held the output, and printed from the hold file where I selected each column for printing based on the value of the flag.
Sorry if I am inarticulate but the hour is late.
HTH.


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
 
Posts: 252 | Location: USA | Registered: April 15, 2003Reply With QuoteReport This Post
Virtuoso
posted Hide Post
George,

Is this what you are looking for?
  
-SET &ECHO=ALL;
DEFINE FILE CAR
NSALES/I6 MISSING ON=IF SALES EQ 0 THEN MISSING ELSE SALES;
END
TABLE FILE CAR
SUM NSALES ACROSS MPG
BY CAR
ON TABLE SET HIDENULLACRS ON
END


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1976 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Master
posted Hide Post
Danny,
That's pretty much what I have - with a couple of wrinkles...



DEFINE FILE XYZ
UNITS/D7C MISSING ON = IF SOLDBY EQ 'UN' THEN PQTY ELSE MISSING;
END

-SET &PRICESTRING=IF &SHOWPRICE EQ 1 THEN 'KG AS ''Kilos'' UNITS AS ''Units'' FOBT AS ''FOB,TOTAL'''
-                   ELSE 'KG AS ''Kilos'' UNITS AS ''Units''';

SET NODATA=''
SET HIDENULLACRS=ON

TABLE FILE XYZ
SUM
&PRICESTRING
ACROSS YEAR AS ''
END


Hmmm.... do I need a BY statement I wonder ...

Yes I do ! (just looked it up):
"Hides columns with missing data in ACROSS groups within a BY-generated page break."

This message has been edited. Last edited by: George Patton,


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Reply With QuoteReport This Post
Master
posted Hide Post
Still no joy....

The UNITS column still shows up - with the NODATA dot as expected. But the HIDENULLACRS just isn't working...

DEFINE FILE XYZ
UNITS/D7C MISSING ON = IF SOLDBY EQ 'UN' THEN PQTY ELSE MISSING;
END

TABLE FILE XYZ
SUM
PQTY
UNITS
BY PDESC
ACROSS BL_YEAR
ON TABLE SET HIDENULLACRS ON
WHERE PSCODE EQ '&SUPPLIER' AND BL_YEAR GE 2010;
ON TABLE PCHOLD FORMAT PDF
END

It looks like HIDENULLACRS only works if there is a single ACROSS field ...

This message has been edited. Last edited by: George Patton,


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Reply With QuoteReport This Post
Master
posted Hide Post
It looks like I'll have to use Jimster's method ...


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
George,
Works well with 2 ACROSS fields:
  
-SET &ECHO=ALL;
DEFINE FILE CAR
NSALES/I6 MISSING ON=IF SALES EQ 0 THEN MISSING ELSE SALES;
END
TABLE FILE CAR
SUM NSALES ACROSS MPG ACROSS SEATS
BY CAR
ON TABLE SET HIDENULLACRS ON
END


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1976 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Master
posted Hide Post
Danny,

You have two ACROSS fields and a single object field.

My situation is this, which doesn't work. The NSALES column still shows up even though all values are null.

-SET &ECHO=ALL;
DEFINE FILE CAR
SALES=0;
NSALES/I6 MISSING ON=IF SALES EQ 0 THEN MISSING ELSE SALES;
END
TABLE FILE CAR
SUM NSALES MPG ACROSS SEATS
BY CAR
ON TABLE SET HIDENULLACRS ON
END


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Reply With QuoteReport This Post
Member
posted Hide Post
HI George,

Did you resolve your issue ? I am having same problem and i cant have it working

thanks!!!
Pats.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 15 | Registered: February 11, 2014Reply With QuoteReport This Post
Master
posted Hide Post
Oh boy, this goes back ...

I worked around this in an entirely different way. Your query revived my interest - for a while - but again I've come up with a dead end.

The example in the Dev Studio online help seems to work, but it has me baffled. You definitely need a style section and it also seems to be optimal if you use PAGE-BREAK.

Maybe someone else can come up with something more useful ....


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [WORKED AROUND] Set numeric values to Null and hide column

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.