When I run the below code for HTML my column title backcolor for dealer cost is the same as the car title. When I change it to AHTML it changes to BLue. How do I control the backcolor and color of the delaer_cost title?
TABLE FILE CAR PRINT DEALER_COST BY CAR ACROSS MODEL ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT AHTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty, $ ENDSTYLE ENDThis message has been edited. Last edited by: Jay Potter,
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
May 26, 2015, 04:55 PM
susannah
you're using a canned style sheet, so open it up and dig into it...
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
May 28, 2015, 08:37 AM
Jay Potter
I did as suggested and I remember trying this before. The RGB color being displayed is rgb(45 102 182). There isn't anything in that file close to it. I entered every RGB in a color display app and nothing showed close to it. I found in the past that there are somethings you can not override for active reports. I think this is one of them. I thought i may have missed something and someone else had this problem and found a solution.
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
May 28, 2015, 08:53 AM
Rifaz
Jay Potter.. Just FYI... What I do to get the RGB value of color you're looking for Do print screen-->paste it in mspaint-->color picker->Edit colors
-Rifaz
WebFOCUS 7.7.x and 8.x
May 28, 2015, 08:55 AM
Jay Potter
Thank You
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
May 28, 2015, 08:58 AM
Jay Potter
Or use this link to download a colordetector. Hover the mouse over the color and give you the numbers.
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
May 28, 2015, 09:44 AM
Francis Mariani
It appears there is a loophole in the WebFOCUS stylesheet selectors - there appears to be no way to reference the across column titles for Active HTML.
After some digging with html developer tools (F12) I discovered the background colour is applied to the table row using an Active HTML css class. The font is set to monospace because it's contained within a "tt" html tag (which, by the way, is not supported in HTML 5).
I would open a case and wait a year or two and then have the case closed without resolution. In the meantime, here is a workaround - include some css to override the default Active HTML behaviour:
TABLE FILE CAR
PRINT
DEALER_COST
BY CAR
ACROSS MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN
<html>
<style>
/* override Active HTML across column title background colour */
.arGridColumnHeading { background-color: rgb(102,102,102); }
/* override Active HTML across column title font (within a custom html tag "tt" */
.arGridColumnHeading tt { font-family: "TREBUCHET MS"; font-size: 9pt; font-weight: bold; }
</style>
</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
May 28, 2015, 11:13 AM
Jay Potter
That was perfect!!! That is why you are the man. Thanks
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
May 28, 2015, 05:01 PM
Francis Mariani
Interestingly this only occurs when there is one measure going across - if there are two measures, the column titles are styled properly. I'll open a case.
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
June 04, 2015, 03:59 PM
Jay Potter
I tried to search on the web for this, but is there a way to make the column widths wider or spacing between the columns. It doesn't appear that you can do this. I thought you may be hiding some more tricks up your sleeve.
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
June 04, 2015, 04:14 PM
Francis Mariani
Normally, ACROSSCOLUMN WRAP would work, but the bug prevents it from working - when there is only one verb object the style is not applied.
This works:
TABLE FILE CAR
PRINT
DEALER_COST
RETAIL_COST
BY CAR
ACROSS MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, ACROSSCOLUMN=DEALER_COST, WRAP=4, $
ENDSTYLE
END
-RUN
This does not:
TABLE FILE CAR
PRINT
DEALER_COST
BY CAR
ACROSS MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, ACROSSCOLUMN=DEALER_COST, WRAP=4, $
ENDSTYLE
END
-RUN
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
June 04, 2015, 04:18 PM
Francis Mariani
Maybe adding some padding to the column titles is the quickest way to make the columns wider, unfortunately this affects all columns, including the BY columns.
TABLE FILE CAR
PRINT
DEALER_COST
BY CAR
ACROSS MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN
<html>
<style>
/* override Active HTML across column title background colour */
.arGridColumnHeading { background-color: rgb(102,102,102); }
/* override Active HTML across column title font (within a custom html tag "tt" */
.arGridColumnHeading tt { font-family: "TREBUCHET MS"; font-size: 9pt; font-weight: bold; padding-left: 40px; padding-right: 40px; }
</style>
</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
June 04, 2015, 04:22 PM
Jay Potter
Ok! Thanks for trying. I had tried the wrap and when it didn't work I figured it was me.
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
June 04, 2015, 04:27 PM
Jay Potter
That did work for me. I originally tried to use width: xx but that didn't work for me. Thanks again.
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
