 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Across Data Title Backcolor
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Across Data Title Backcolor Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED]Across Data Title Backcolor | Login/Join |
| Guru |
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 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 | ||
|
| Expert |
you're using a canned style sheet, so open it up and dig into it...
| |||||
|
| Guru |
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 | |||
|
| Guru |
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 | |||
|
| Guru |
Thank You WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster | |||
|
| Guru |
Or use this link to download a colordetector. Hover the mouse over the color and give you the numbers. http://www.cosmin.com/download.html WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster | |||
|
| Expert |
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 | |||
|
| Guru |
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 | |||
|
| Expert |
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 | |||
|
| Guru |
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 | |||
|
| Expert |
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 | |||
|
| Expert |
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 ENDFrancis 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 | |||
|
| Guru |
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 | |||
|
| Guru |
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 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Across Data Title Backcolor
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Across Data Title BackcolorCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |