Focal Point
[SOLVED] Styling Column Titles - Active Report With Across.

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

June 23, 2017, 01:10 PM
David Briars
[SOLVED] Styling Column Titles - Active Report With Across.
TABLE FILE CAR
SUM SALES AS 'Amount'
BY COUNTRY
BY CAR
ACROSS BODYTYPE
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET STYLE *
 TYPE=ACROSSTITLE, SIZE=16, COLOR=RED, BACKCOLOR=GREEN, FONT='Arial', JUSTIFY='CENTER', $
 TYPE=ACROSSVALUE, SIZE=16, COLOR=RED, BACKCOLOR=GREEN, FONT='Arial', JUSTIFY='CENTER', $
 TYPE=TITLE,       SIZE=16, COLOR=RED, BACKCOLOR=GREEN, FONT='Arial', JUSTIFY='CENTER', $ 
ENDSTYLE
END  

My requirement is for the 'column headings' of the SALES columns to be Arial, centered, and a font size of 16.

When I run the above code, the 5 instances of 'Amount' seem to be 'Courier', left justified, and a very small font size.

This message has been edited. Last edited by: FP Mod Chuck,




Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster
June 23, 2017, 06:02 PM
Francis Mariani
This appears to be an age-old problem:
Active Reports Across Title Styling


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 23, 2017, 09:50 PM
Francis Mariani
Upon inspection of the resulting HTML I discovered the across value titles are contained within tt tags - why on earth would Teletype Text Element be used? Unless someone else has a smarter solution, a workaround might be to include some CSS to alter the default style of tt or one of its parent elements.

<table style="color:#FF0000;background-color:#FFFF00;" cellpadding="0" cellspacing="0" border="0" width="100%">
    <tbody>
        <tr valign="bottom">
            <td class="undefined" onmouseover="setCurCell(0,'TCOL_0_C_2')" align="undefined" style="width:undefinedpx;" id="TCOL_0_C_2">
                <tt>Amount</tt></td>
            <td>&nbsp;</td>
            <td height="20" width="20" style="white-space:nowrap" align="left" valign="bottom">
        <div id="popid0_2">
        <div onclick="ibiMenu.Showmenu(event,0,'2','popid0_2',true,1);" class="null" style="width:15px;cursor:pointer;">
        <div style="border:none;width:16px;height:16px;font-size:0px;">
        [IMG]data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA2ZpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYwIDYxLjEzNDc3NywgMjAxMC8wMi8xMi0xNzozMjowMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowODNCOUMyMzExMjA2ODExOTdBNUE1NTQ2OEE3RENDMSIgeG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDpDMjlFNjZFNkZDQzYxMUUwOTREMkYwMjk4QzY5QUMxNyIgeG1wTU06SW5zdGFuY2VJRD0ieG1wLmlpZDpDMjlFNjZFNUZDQzYxMUUwOTREMkYwMjk4QzY5QUMxNyIgeG1wOkNyZWF0b3JUb29sPSJBZG9iZSBQaG90b3Nob3AgQ1M1IE1hY2ludG9zaCI+IDx4bXBNTTpEZXJpdmVkRnJvbSBzdFJlZjppbnN0YW5jZUlEPSJ4bXAuaWlkOjA4M0I5QzIzMTEyMDY4MTE5N0E1QTU1NDY4QTdEQ0MxIiBzdFJlZjpkb2N1bWVudElEPSJ4bXAuZGlkOjA4M0I5QzIzMTEyMDY4MTE5N0E1QTU1NDY4QTdEQ0MxIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+UIY5agAAAGtJREFUeNpi/P//PwMlgImBQjA4DdgNxP9x4HIM1aBARMPG/7GDu0AsiK4emwEgPBOLAWnY1OIyQAmL7QykGIDuijRyDAD59x0Q78ajhoEFTwy9B+JOID6LLxoZCSRlQahBZBswEvICQIABADagFmfUTQn/AAAAAElFTkSuQmCC[/IMG]</div></div></div></td></tr></tbody></table>



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 23, 2017, 10:15 PM
Francis Mariani
A bit of CSS gets you a little further, though centre alignment won't work.

-RUN

-HTMLFORM BEGIN
<style>
tt { font-size: 18pt; font-family: 'Arial', text-align: center; }
</style>
-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 26, 2017, 10:32 AM
David Briars
Thank you for the 'Active Reports Across Title Styling' thread link, Francis.

The OP does a nice job a describing the scenario.

This workaround from that thread will work for me:
quote:
Try this to get rid of the column names:
SUM
'CAR.BODY.SALES' AS '&|nbsp;'