Hi all,

I have the following code:

  
DEFINE FILE CAR
L_TOTAL/I8 WITH LENGTH = L_TOTAL+LENGTH;
L_COUNT/I8 WITH LENGTH = L_COUNT+1;
END
-RUN
TABLE FILE CAR
PRINT MODEL
LENGTH
L_TOTAL
L_COUNT
END

I want to put the L_TOTAL AND L_COUNT field as a totals for the LENGTH.

Here is desired result:

 
MODEL        LENGTH
-----        ------
a            1    
b            2 
c            3
d            4
             --
SUM TOTAL:   10
COUNT:        4 
 

The report output is HTML.

I have tried to use the SUBFOOT but I can't insert the totals under the LENGTH column...

LG,

You really need to read the posts that others make as well as adding your own. You might learn something else

If you had read some recent posts then you would most likely have tried HEADALIGN=BODY -

L_TOTAL NOPRINT
L_COUNT NOPRINT
FOOTING
"SUM TOTAL: <L_TOTAL"
"COUNT: <L_COUNT"
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
TYPE=REPORT, HEADALIGN=BODY, $

T

You should also check out RECAP.