Hello,

I have a report in which I have to subtotal for specific fields. I am giving the subtotal command in subfoot. However the alignment is not proper. They are not aligned in the way expected.

DEFINE FILE CAR
temp_car/A20=CAR.COMP.CAR;
END

TABLE FILE CAR
PRINT 
     CAR.BODY.SEATS
     CAR.BODY.DEALER_COST
     CAR.BODY.RETAIL_COST
     CAR.BODY.SALES
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR

ON  CAR.COMP.CAR SUBFOOT
"Subtotal for <temp_car :  <ST.DEALER_COST <ST.RETAIL_COST "
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=SUBFOOT,
     FONT='TIMES NEW ROMAN',
     SIZE=9,
     STYLE=BOLD,
     HEADALIGN=BODY,
$
ENDSTYLE
END  

The above posted is a sample code of the car file. I want the subtotals only for dealer cost and retail cost under them. I have used the COLSPAN and POSITION but to no effect.
The output formats are in PDF and EXL2K.

I have also used SET SUMMARYLINES=EXPLICIT, with the subtotal command. But each field is shown in a separate page when used. (I dont understand its behaviour here)

Any suggestions will be useful.

Thanks,

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

Hello,

By simply using the DS, I get the following code with the alignment desired:

  
-* File sumant02.fex
DEFINE FILE CAR
temp_car/A20=CAR.COMP.CAR;
END

TABLE FILE CAR
PRINT 
     SEATS
     DEALER_COST
     RETAIL_COST
     SALES
BY  COUNTRY
BY  CAR
     
ON CAR SUBFOOT WITHIN 
"Subtotal for<temp_car   <DEALER_COST<RETAIL_COST "
" <+0> <+0> <+0> <+0> <+0> "
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=REPORT,
     GRAPHCOLOR='GREEN',
$
TYPE=DATA,
     COLUMN=N3,
     BACKCOLOR='NONE',
$
TYPE=DATA,
     COLUMN=N4,
     BACKCOLOR='NONE',
$
TYPE=DATA,
     COLUMN=N5,
     BACKCOLOR='NONE',
$
TYPE=DATA,
     COLUMN=N6,
     BACKCOLOR='NONE',
$
TYPE=DATA,
     COLUMN=N2,
     BACKCOLOR='NONE',
$
TYPE=DATA,
     COLUMN=N1,
     BACKCOLOR='NONE',
$
TYPE=SUBFOOT,
     BY=2,
     HEADALIGN=BODY,
$
TYPE=SUBFOOT,
     BY=2,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
     BY=2,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
     BY=2,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
     BY=2,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     COLSPAN=1,
     WRAP=ON,
     JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
     BY=2,
     LINE=1,
     OBJECT=FIELD,
     ITEM=2,
     COLSPAN=1,
     WRAP=ON,
     JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
     BY=2,
     LINE=1,
     OBJECT=FIELD,
     ITEM=3,
     COLSPAN=1,
     WRAP=ON,
     JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
     BY=2,
     LINE=2,
     OBJECT=TEXT,
     ITEM=1,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
     BY=2,
     LINE=2,
     OBJECT=TEXT,
     ITEM=2,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
     BY=2,
     LINE=2,
     OBJECT=TEXT,
     ITEM=3,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
     BY=2,
     LINE=2,
     OBJECT=TEXT,
     ITEM=4,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
     BY=2,
     LINE=2,
     OBJECT=TEXT,
     ITEM=5,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
     BY=2,
     LINE=2,
     OBJECT=TEXT,
     ITEM=6,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=REPORT,
     OBJECT=MENU,
     COLOR='WHITE',
     HOVER-COLOR=RGB(66 70 73),
     BACKCOLOR=RGB(102 102 102),
     HOVER-BACKCOLOR=RGB(218 225 232),
     BORDER-COLOR='WHITE',
$
TYPE=REPORT,
     OBJECT=STATUS-AREA,
     COLOR='WHITE',
     BACKCOLOR=RGB(102 102 102),
$
TYPE=REPORT,
     OBJECT=CURRENT-ROW,
     HOVER-BACKCOLOR=RGB(218 225 232),
     BACKCOLOR=RGB(200 200 200),
$
TYPE=REPORT,
     OBJECT=CALC-AREA,
     COLOR='WHITE',
     BACKCOLOR=RGB(102 102 102),
$
ENDSTYLE
END

Notice the use of the WITHIN option of SUBFOOT: it dispenses you of using the ST. prefix when you are summing in the request.

Hello Daniel,

Thanks a lot for the reply.
I have been able to solve my alignment issue.
Thanks for the tip (WITHIN option) in the subfoot.