Thanks!This message has been edited. Last edited by: <José Andrés Vargas Aguilar>,
April 26, 2010, 03:55 PM
Francis Mariani
TABLE FILE CAR
SUM
SALES
BY COUNTRY
ON TABLE HOLD AS H001 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=COUNTRY, CLASS= x64, $
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN
<html>
<head>
<TITLE>WEBFOCUS REPORT</TITLE>
<style type="text/css">
.x64 { font-family:ARIAL; font-size:7pt; font-weight:bold; color:#FFFFFF; background-color:#93ACDB; text-align:center;
border-top: 1.00pt RIDGE #808080; border-bottom: NONE; border-right: 1.00pt RIDGE #808080; border-left: 1.00pt RIDGE #808080; }
</style>
</head>
<BODY>
!IBI.FIL.H001;
</BODY>
</html>
-HTMLFORM 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
April 27, 2010, 12:02 PM
<José Andrés Vargas Aguilar>
Thanks for the answer Francis. But It doesn't work like that for my particular case because the column I need to "style" comes from a COMPUTE on an ACROSS. Similar to this:
DEFINE FILE CAR SALESD/D10 = SALES; END -*************************************** TABLE FILE CAR SUM SALESD NOPRINT BY COUNTRY NOPRINT SUM SALESD NOPRINT BY COUNTRY NOPRINT BY CAR SUM SALESD AS 'Sales' PCT.SALESD/D6.2 WITHIN COUNTRY WITHIN SEATS AS '%' BY COUNTRY NOPRINT BY CAR ACROSS SEATS COMPUTE XTOT_SALESD/D15 = C2; AS 'Total' COMPUTE MYPCT/D12.2 = C2 / C1 * 100; AS '%' -*************************************** ON COUNTRY SUBHEAD "COUNTRY: ON COUNTRY RECOMPUTE AS 'TOTAL' ON TABLE NOTOTAL END
The question would be: how do you modify the style of the las two compute columns XTOT_SALESD and MYPCT ('Total' and '%') from a stylesheet?
I already tried with all the types I know and found and I only managed to affect the other areas of the report but not that one in particular.
Thanks for the help.
April 27, 2010, 12:12 PM
Dan Satchell
This is a duplicate post to this one: ACROSS, COMPUTE AND STYLES. Francis provided the solution in the other post. The problem seems to be that you are missing the ending double quote (") on your SUBHEAD statement.
WebFOCUS 7.7.05
April 27, 2010, 12:21 PM
Francis Mariani
You're not trying very hard.
DEFINE FILE CAR
SALESD/D10 = SALES;
END
TABLE FILE CAR
SUM SALESD NOPRINT
BY COUNTRY NOPRINT
SUM SALESD NOPRINT
BY COUNTRY NOPRINT
BY CAR
SUM SALESD AS 'SALES'
PCT.SALESD/D6.2 WITHIN COUNTRY WITHIN SEATS AS '%'
BY COUNTRY NOPRINT
BY CAR
ACROSS SEATS
COMPUTE XTOT_SALESD/D15 = C2; AS 'TOTAL'
COMPUTE MYPCT/D12.2 = C2 / C1 * 100; AS '%'
ON COUNTRY SUBHEAD
"COUNTRY: <COUNTRY"
ON COUNTRY RECOMPUTE AS 'TOTAL'
ON TABLE NOTOTAL
ON TABLE HOLD AS H001 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=XTOT_SALESD, class=x64, $
TYPE=REPORT, COLUMN=MYPCT, class=x64, $
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN
<html>
<head>
<TITLE>WEBFOCUS REPORT</TITLE>
<style type="text/css">
.x64 { font-family:ARIAL; font-size:7pt; font-weight:bold; color:#FFFFFF; background-color:#93ACDB; text-align:center;
border-top: 1.00pt RIDGE #808080; border-bottom: NONE; border-right: 1.00pt RIDGE #808080; border-left: 1.00pt RIDGE #808080; }
</style>
</head>
<BODY>
!IBI.FIL.H001;
</BODY>
</html>
-HTMLFORM 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
April 27, 2010, 12:35 PM
<José Andrés Vargas Aguilar>
Actually this is only an example code because I considered the actual code too big to be posted.
Also, neither solutions worked. Here is a part of the actual code. What I need to "style" are the labels from the computes below the across ('Totales', 'Concent.', etc):
SUM MONTOS AS 'Monto' CONMORA NOPRINT MORA30 NOPRINT CANTIDADES AS 'Cant.' CANTMORA NOPRINT CANT30 NOPRINT
BY &wf_agrupa
ACROSS MORAMIN NOPRINT ACROSS DIA AS 'Dias de Mora' COMPUTE TVAL/D20.2 = C7; AS 'TOTALES' COMPUTE TCAN/D20 = C10; AS 'TEST' COMPUTE PVAL/D20.2% = 100*C7/C1; AS 'CONCENT.' COMPUTE PCAN/D20.2% = 100*C10/C4; AS '' COMPUTE CONM/D20.2% = 100*C8/C2; AS 'MORA' COMPUTE CANM/D20.2% = 100*C11/C5; AS '' COMPUTE MOR3/D20.2% = 100*C9/C3; AS 'MORA > 30' COMPUTE CAN3/D20.2% = 100*C12/C6; AS ''
ON TABLE COLUMN-TOTAL
-INCLUDE bkw54/bkwstyleanalisis.fex
-* *******************************************
-* Amongst other stuff I have this on bkw54/bkwstyleanalisis.fex
FYI, I initially thought this labels would be ACROSSTITLE or ACROSSVALUE but they dont get affected by the ACROSSTITLE and ACROSSVALUE definitions I already have.
I used the -HTMLFORM advice Francis gave me but it didn't do the job either.