Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [NOT COMPLETELY SOLVED] How to style the sub-total label area

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[NOT COMPLETELY SOLVED] How to style the sub-total label area
 Login/Join
 
Expert
posted
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
Would that be increasing or decreasing the gap ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
Whats the current code ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Virtuoso
posted Hide Post
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

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Virtuoso
posted Hide Post
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

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Virtuoso
posted Hide Post
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

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Expert
posted Hide Post
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.

How to Style Subtotal and Grand Total Tags
TYPE={SUBTOTAL|GRANDTOTAL}, OBJECT=TAG,
[FONT=font], [SIZE=size], [STYLE=style],
[COLOR={color|RGB({rgb|#hexcolor})],
[drilltype=drillparms], $


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Guru
posted Hide Post
hello.


How do I Style the SUBTOTAL of the first BY noprint?


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
Guru
posted Hide Post
quote:
Originally posted by Ricardo Augusto:
hello.


How do I Style the SUBTOTAL of the first BY noprint?



Got it. That OBJECT = TAG did the trick!

thans Francis


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [NOT COMPLETELY SOLVED] How to style the sub-total label area

Copyright © 1996-2020 Information Builders