Focal Point
[CLOSED] Conditional Formatting for AHTML and ACROSS

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

November 11, 2014, 02:42 PM
Joe Beydoun
[CLOSED] Conditional Formatting for AHTML and ACROSS
I can't get my conditional formatting to work for output type AHTML even though it works with HTML.

This code will not execute the formatting, switching the formatting to HTML will fix it.

Thanks for the help!

TABLE FILE CAR
SUM SALES
ACROSS HIGHEST COUNTRY
BY MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ONLINE-FMT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,
BORDER=LIGHT,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
STYLE=NORMAL,
COLOR=RED,
WHEN=N2 GT 0,
$
END

This message has been edited. Last edited by: <Kathryn Henning>,


version 8202M
Reporting Server on
Windows Server using DB2 Connect to access data from iseries.
November 11, 2014, 03:54 PM
Francis Mariani
This should work:

TABLE FILE CAR
SUM SALES
ACROSS HIGHEST COUNTRY
BY MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ONLINE-FMT
HTML
AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,
BORDER=LIGHT,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
ACROSSCOLUMN=SALES,
STYLE=NORMAL,
COLOR=RED,
WHEN=SALES GT 0,
$
END

I've never understood why the WebFOCUS GUI generates style sheet attributes based on the positional thingy.

This message has been edited. Last edited by: Francis Mariani,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 11, 2014, 03:55 PM
Francis Mariani
What do you assume N1 and N2 to be and why are they different?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 12, 2014, 07:29 AM
MartinY
Francis, your output it still in HTML where styling does work, but in AHTML seems un-effective...


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
November 12, 2014, 11:19 AM
Francis Mariani
Oops, my bad. I've changed the output format and it works:

TABLE FILE CAR
SUM SALES
ACROSS HIGHEST COUNTRY
BY MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ONLINE-FMT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,
BORDER=LIGHT,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
ACROSSCOLUMN=SALES,
STYLE=NORMAL,
COLOR=RED,
WHEN=SALES GT 0,
$
END






Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server