I would like to position the total line and where the totals appear on the report.

Example:
-------------------------------------------------
ID   TERM  Name   Group     Status   MoreCols...
123  2012  Joe    Science   Applied  ...
234  2012  Fred   Science   Accepted ...

Total Science    2     Applied:  2     
                       Accepted: 1   
                       Denied:   0

567  2012  Chris  Arts      Accepted ...
678  2012  Linda  Arts      Denied   ...

Total Science    2     Applied:  2     
                       Accepted: 1   
                       Denied:   1

Total            4     Applied:  4
                       Accepted: 2
                       Denied:   1
---------------------------------------------------

What is happening for the total section, it wraps
and is on a separate line from the numerical totals.

Total
Science
                                                     2      1         0

I tried changing the section below with No wrap as well changing col numbers and wrap numbers, but neither seemed to work and caused error messages

TYPE=REPORT,
COLUMN=N11,
WRAP=6.000000,
$

If I can't position the totals could I hide the detail display of Applied, Accepted and Denied and only show them in the subtotal and total rows all on one line rather than a line for the word "Total" and a second line for the actual totals?

TABLE FILE SQLOUT
PRINT 
     ID
     NAME
     ACADEMIC_PERIOD
     COLLEGE
     CAMPUS
     PROGRAM
     APPLICATION_DATE/HDMtYY-
     LATEST_DECISION
     LATEST_DECISION_DESC
     LATEST_DECISION_DATE/HDMtYY-
     SPRHOLD_REASON
     FAFSA_RECEIVED
     APPLIED/I5
     ACCEPTED/I5
     DENIED/I5
BY  LOWEST PROGRAM NOPRINT 
     
ON PROGRAM SUBTOTAL AS '*TOTAL'
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=REPORT,
     COLUMN=N13,
     WRAP=6.000000,
$
TYPE=REPORT,
     COLUMN=N11,
     WRAP=6.000000,
$
TYPE=REPORT,
     COLUMN=N10,
     WRAP=6.000000,
$
TYPE=REPORT,
     COLUMN=N5,
     WRAP=6.000000,
$
TYPE=REPORT,
     COLUMN=N4,
     WRAP=6.000000,
$
TYPE=REPORT,
     COLUMN=N3,
     WRAP=6.000000,
$
TYPE=REPORT,
     COLUMN=N2,
     WRAP=6.000000,
$
ENDSTYLE
END

This message has been edited. Last edited by: Kerry,

You cannot really alter positions of fields in a COLUMN-TOTAL or SUMMARIZE. They are designed to display on the very same column whose total they represent.

For the layout you want you will need to use either a FOOTING or a TABLE SUBFOOT.

Using SUBFOOT, there are a few options. Here is one using HEADALIGN=BODY:

  
-* File sxschech01.fex
DEFINE FILE CAR
DUM/A1=' ';
END
TABLE FILE CAR
SUM 
     DEALER_COST
     RETAIL_COST
     SALES
     COMPUTE ONE/I5 = 1; NOPRINT 
BY DUM NOPRINT
BY  LOWEST COUNTRY
BY  LOWEST CAR
BY  LOWEST BODYTYPE
     
ON COUNTRY SUBFOOT
"Total<COUNTRY<ST.ONE Dealer:<ST.DEALER"
" <+0> <+0> <+0> Retail:<ST.RETAIL"
" <+0> <+0> <+0> Sales:<ST.SALES"
" "
ON DUM SUBFOOT
"Grand Total<+0> <ST.ONE Dealer:<ST.DEALER"
" <+0> <+0> <+0> Retail:<ST.RETAIL"
" <+0> <+0> <+0> Sales:<ST.SALES"
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=SUBFOOT, HEADALIGN=BODY,
$
TYPE=SUBFOOT, ITEM=5, JUSTIFY=RIGHT,
$
ENDSTYLE
END

Thanks Daniel,

Was able to use your code as a guide to make some progress in producing the report. Couple of questions, the totals were coming out with decimals even though the source data does not contain decimals and I did
APPLIED/I5.

I was able to get the totals to show without decimals by doing a
COMPUTE APPLIED_INT/I5 = INT(APPLIED); NOPRINT

Applied:<ST.APPLIED_INT

For some reason, the totals are aligning left justified even though the code you provided had JUSTIFY=RIGHT

Example:
10
22
4

Rather than
10
22
04

The leading zero doesn't exist on the report, only put in since I can't tell if display will line up after this is posted.

I figured out how to get the "Total" and totals to appear on one line rather than wrapping and taking 3 lines. I noticed that the Summary report doesn't wrap, while the detail report wraps. I turned the detail report into a summary by deleting the ID, Name, etc. and noticed that the Total now appeared as one line without wrapping. I then started adding back in the detail fields one by one and the Total remained on one line. Not knowing what was causing the report to now work, switched to the code view and compared the code between the original version and the revised version and the difference between the two was that the original version used the keyword "PRINT" while the revised version used the keyword "SUM".

Still would be curious about the version using subfoot layout getting the numbers to right justify, but the above will meet the needs for this report for now.