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     [CLOSED] Empty cells in Across
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Empty cells in Across
 Login/Join
 
Platinum Member
posted
I try to build an html report with webfocus. I build it by using the across
method in the empty cells appears a “.” (dot)
How can I format the empty cells. I also use a drilldown in the
Report by using the DRILLMENUITEM method. I want to have nothing in the empty cells
because the drilldown also works on the “.” And that makes not really sense.
thanks a lot

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


WF Production Version: 7.7.02M
WF Test Version: 7.7.02M
Developer Studio: 7.7.02
HTML, EXL2K, FLEX, PDF,PPT
 
Posts: 156 | Location: Essen Germany | Registered: December 02, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Controlling the '.' is done with the NODATA setting (SET NODATA='n/a' for instance will display n/a in stead of a dot).
And for across you need to use either the SUM verb, or use the new setting for compressing the across output, SET ACROSSPRT = COMPRESSED, although I don't know exactly when this setting was introduced. So it could be that it is not yet available in the release you're working with ...


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
For the drilldown it will make no difference if there is a dot or a really empty cell. You'll get the link anyway.
To control this use conditional styling. Consider the following example:
SET NODATA=''
SET ACROSSPRT = NORMAL
TABLE FILE CAR
PRINT 
     SEATS
BY 'CAR.COMP.CAR'
ACROSS 'CAR.ORIGIN.COUNTRY'
ON TABLE NOTOTAL
ON TABLE SET STYLE *
$
TYPE=REPORT,
     FONT='VERDANA',
     SIZE=9,
$
TYPE=DATA,
     ACROSSCOLUMN=N1,
     WHEN=N2 NE 0,
     FOCEXEC=TEST,
$
ENDSTYLE
END
Whether or not the link is shown depends on the WHEN clause in the styling.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Empty cells in Across

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