[SOLVED] Across to Bottom

Hi Carlos,

For our experts to better help you, can you please elaborate a bit more: what do you mean with "having across on the bottom"? If we do something like column total, is that what you want? A detailed example with any of our test files (CAR, EMPDATA) would be nice.

Cheers,

Kerry

Kerry Zhan
Focal Point Moderator
Information Builders, Inc.

Posts: 1948 | Location: New York | Registered: November 16, 2004

Ignored post by Kerry posted

Show Post

Carlos Dias

Platinum Member

posted

Hide Post

Here is an example:

TABLE FILE CAR
SUM 
     CAR.SPECS.WIDTH AS ''
     CAR.SPECS.HEIGHT AS ''
BY  LOWEST CAR.BODY.DEALER_COST
ACROSS LOWEST CAR.BODY.SEATS
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=ACROSSVALUE,
     ACROSS=1,
     BACKCOLOR='WHITE',
$
ENDSTYLE
END

What I would like to see is the ACROSS SEATS like a total.

Thanks,
Carlos Dias

WebFOCUS version: 7.6
Linux/Windows
HTML, Excel

Posts: 127 | Location: Aveiro, Portugal | Registered: February 04, 2011

Ignored post by Carlos Dias posted

Show Post

Kerry

Expert

posted

Hide Post

Hi Carlos,

From our technicals: is the following output truly what you want? If so, it will be challenging to do. Otherwise, please let us know how you would want the output to be.

Cheers,
Kerry

Kerry Zhan
Focal Point Moderator
Information Builders, Inc.

Posts: 1948 | Location: New York | Registered: November 16, 2004

Ignored post by Kerry posted

Show Post

George Patton

Master

posted

Hide Post

ON TABLE ROW-TOTAL

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Ignored post by George Patton posted

Show Post

Danny-SRL

Virtuoso

posted

Hide Post

Carlos,
Never underestimate the power of Focus!

  
-SET &ECHO=ALL;
-* File FOOT01.fex
TABLE FILE CAR
BY SEATS
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SAVE
END
-RUN
-SET &L=&LINES;
-SET &FOOT='" ';  
-REPEAT #R FOR &I FROM 1 TO &L;
-READ SAVE,&S
-SET &FOOT=&FOOT | '<+0>' | &S ; 
-#R
-SET &FOOT=&FOOT | '"';  
-RUN

TABLE FILE CAR
SUM 
     CAR.SPECS.WIDTH AS ''
     CAR.SPECS.HEIGHT AS ''
BY  LOWEST CAR.BODY.DEALER_COST
ACROSS LOWEST CAR.BODY.SEATS NOPRINT
FOOTING
" <+0>SEATS "
&FOOT
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=FOOTING, HEADALIGN=BODY, $
TYPE=FOOTING, LINE=1, ITEM=2, COLSPAN=6, $
-REPEAT #FOOT FOR &I FROM 1 TO &L;
-SET &J=&I + 1;
TYPE=FOOTING, LINE=2, ITEM=&J, COLSPAN=2, $
-#FOOT
ENDSTYLE
END