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

 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

 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

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

  
<TD COLSPAN=4>
TOTAL MODEL V12XKE AUTO</TD>
<TD ALIGN=RIGHT>

  
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

  
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

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.

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

quote:

Originally posted by Ricardo Augusto:
hello.


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