[NOT COMPLETELY SOLVED] How to style the sub-total label area
I'm hoping to add a LEFTGAP tag to styling for the label area of the subtotal row, the first item in a subtotal row, "Total sort-field name".
I guess this is not possible...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
March 26, 2013, 06:47 PM
Waz
Would that be increasing or decreasing the gap ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
March 26, 2013, 06:49 PM
Francis Mariani
I'd like to add some indentation to the Total label, depending on the sortfield - first sort field - half an inch, second sort field - one inch...
But I don't think this is possible...
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
March 26, 2013, 06:59 PM
Waz
Whats the current code ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
March 26, 2013, 08:23 PM
Francis Mariani
TABLE FILE CAR
SUM
SALES
BY COUNTRY SUBTOTAL AS 'TOTAL COUNTRY'
BY CAR SUBTOTAL AS 'TOTAL CAR'
BY MODEL SUBTOTAL AS 'TOTAL MODEL'
BY BODYTYPE
END
People have asked for this before: how to align the subtotal label to the appropriate column? Mock up:
COUNTRY CAR MODEL BODYTYPE SALES
------- --- ----- -------- -----
ENGLAND JAGUAR V12XKE AUTO CONVERTIBLE 0
TOTAL MODEL V12XKE AUTO 0
XJ12L AUTO SEDAN 12000
TOTAL MODEL XJ12L AUTO 12000
TOTAL CAR JAGUAR 12000
JENSEN INTERCEPTOR III SEDAN 0
TOTAL MODEL INTERCEPTOR III 0
TOTAL CAR JENSEN 0
TRIUMPH TR7 HARDTOP 0
TOTAL MODEL TR7 0
TOTAL CAR TRIUMPH 0
TOTAL COUNTRY ENGLAND 12000
In pre-web days, we would use asterisks to denote the level:
COUNTRY CAR MODEL BODYTYPE SALES
------- --- ----- -------- -----
ENGLAND JAGUAR V12XKE AUTO CONVERTIBLE 0
* TOTAL MODEL V12XKE AUTO 0
XJ12L AUTO SEDAN 12000
* TOTAL MODEL XJ12L AUTO 12000
** TOTAL CAR JAGUAR 12000
JENSEN INTERCEPTOR III SEDAN 0
* TOTAL MODEL INTERCEPTOR III 0
** TOTAL CAR JENSEN 0
TRIUMPH TR7 HARDTOP 0
* TOTAL MODEL TR7 0
** TOTAL CAR TRIUMPH 0
*** TOTAL COUNTRY ENGLAND 12000
But we have moved on to the 21st century, haven't we?
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
March 27, 2013, 04:13 AM
Danny-SRL
Francis,
If you view the source you will see that WF generates:
<TD COLSPAN=4>
TOTAL MODEL V12XKE AUTO</TD>
<TD ALIGN=RIGHT>
So, you are left to use SUBFOOT...
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
March 28, 2013, 08:54 AM
Danny-SRL
And here is some code:
DEFINE FILE CAR
TCOUNTRY/A25 ='Total Country ' | COUNTRY;
TCAR/A30 ='Total Car ' | CAR;
TMODEL/A40 ='Total Model ' | MODEL;
END
TABLE FILE CAR
SUM
SALES
BY COUNTRY SUBFOOT
"<TCOUNTRY <ST.SALES"
BY CAR SUBFOOT
" <TCAR <ST.SALES"
BY MODEL SUBFOOT
" <TMODEL <ST.SALES"
BY BODYTYPE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBFOOT, HEADALIGN=BODY, $
TYPE=SUBFOOT, BY=1, ITEM=1, COLSPAN=3,$
TYPE=SUBFOOT, BY=2, ITEM=2, COLSPAN=2,$
TYPE=SUBFOOT, BY=3, ITEM=1, COLSPAN=2,$
ENDSTYLE
END
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
March 28, 2013, 10:12 AM
Francis Mariani
Danny,
Thanks very much. I am aware of using SUBFOOT where we can do a lot more styling. It's too bad we cannot manipulate SUBTOTAL to some degree.
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
March 29, 2013, 03:15 AM
Danny-SRL
Francis,
I couldn't agree more. One can style each column of a subtotal. For example:
TABLE FILE CAR
SUM RCOST DCOST SALES
BY COUNTRY
BY CAR
BY BODYTYPE
ON COUNTRY SUBTOTAL
ON CAR SUBTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBTOTAL, BY=1, COLUMN=SALES, STYLE=BOLD, $
TYPE=SUBTOTAL, BY=2, COLUMN=P4, STYLE=BOLD, $
TYPE=SUBTOTAL, BY=2, COLUMN=P5, STYLE=BOLD, $
ENDSTYLE
END
If one could have something like: TYPE=SUBTOTAL, BY=2, COLUMN=CAR, POSITION=CAR, $ to place the "Total CAR" under the CAR column.
A NFR?
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
September 23, 2014, 05:37 PM
Francis Mariani
In v7.7.05 we have a little relief!
quote:
Identifying Tags for SUBTOTAL and GRANDTOTAL Lines The tag is the text that is displayed in the leftmost portion of each SUBTOTAL and GRANDTOTAL row in a report. The tag is used to identify the type of data represented within this row. The text used to generate this tag can be customized by adding an AS name to the SUBTOTAL syntax. You can define styling for the subtotal and grand total tag separately from the rest of the row. Text attributes available for the tag, including font, color, size, and style, can be used to differentiate and highlight the tags. Additionally, styling can be applied that turns tags into drill-down links. Styling is supported for text attributes only. Cell or column features, such as borders, background color, or justification are not supported. This feature is available for PDF, DHTML, PS, HTML, AHTML, XLSX, and EXL2K formats.