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     [Solved] STYLING AN ACROSSVALUE DEPENDING ON IT'S VALUE
Go
New
Search
Notify
Tools
Reply
  
[Solved] STYLING AN ACROSSVALUE DEPENDING ON IT'S VALUE
 Login/Join
 
Member
posted
TABLE FILE CAR
SUM
RETAIL
BY COUNTRY
ACROSS CAR

END

Using the car table, I am trying to make the font a different color depending on it's value (RETAIL GT 10000). I have tried both the DEFMACRO and TYPE=ACROSSVALUE with a WHEN=RETAIL GT 10000. Can this be done. I think I may have read something that indicated it can't be.

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


WebFOCUS 8.2.01M
Windows, All Outputs
 
Posts: 13 | Registered: July 20, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Maybe this could work for you:
 
SET ACROSSTITLE = SIDE
TABLE FILE CAR
SUM
     SALES
BY  LOWEST COUNTRY
ACROSS LOWEST SEATS
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
 include=endeflt, $
type=report, border=light, $
TYPE=DATA,
     ACROSSCOLUMN=SALES, color=red, 
	 WHEN=SALES GT 10000,
$
ENDSTYLE
END
 


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

 
Posts: 1940 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
FYI :

TYPE=ACROSSTITLE is for the title displayed above the across field

TYPE=ACROSSVALUE is for the across field itself

TYPE=DATA, ACROSSCOLUMN=colABC is for the SUM/PRINT data that lays under the across field

TYPE=DATA, COLUMN=colABC(*) is for the SUM/PRINT data that lays under the across field

Sometime, the above may replace the ACROSSCOLUMN=ColABC to style the data and works where ACROSSCOLUMN doesn't. Never been able to figure why


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2261 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
That worked thank you


WebFOCUS 8.2.01M
Windows, All Outputs
 
Posts: 13 | Registered: July 20, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved] STYLING AN ACROSSVALUE DEPENDING ON IT'S VALUE

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