Hello all!

I am still strugling with totals and subtotals.
How I can make numbers be on a same line with word 'total'?

post the code it has to do with the by clause.


Vipul

DEFINE FILE WEBFINPR
PRNT_DATE/MTRYY = PRNT_DT;
SORT_FIELD/A1 = IF REGION EQ 'MIDTOWN' THEN 'a' ELSE
IF REGION EQ 'CHICAGO' THEN 'b' ELSE
IF REGION EQ 'SAN FRANCISCO' THEN 'c' ELSE
IF ((REGION EQ 'FINPRO SAFE TOTAL') AND
(RPTG_AGT_N EQ ' ')) THEN 'd' ELSE
IF ((REGION EQ 'GRAND TOTAL') AND
(RPTG_AGT_N EQ ' ')) THEN 'e' ELSE 'X';

END



TABLE FILE WEBFINPR SUM
AGT_CITY
WP_CYTD_A/P12C
EP_CYTD_A/P12C
.......
BY SORT_FIELD
BY REGION NOPRINT
BY MIS_ENTTY_AB NOPRINT
BY AGT_CITY NOPRINT
BY RPTG_AGT_N AS 'Agent#'
ON REGION RECAP
WP_CYTD_P/P12C = WP_CYTD_A;
EP_CYTD_P/P12C = EP_CYTD_A;
GRTHP/P9.1%=((WP_CYTD_A - WP_PYTD_A)/(ABS(WP_PYTD_A)))*100;
COMMP/P6.1%=(-COMM_INCUR_CYTD_A/WP_CYTD_A)*100;
RPTD_CYTD_P/P12C =RPTD_CYTD_A;
LOSSP/P9.1%= (RPTD_CYTD_A/EP_CYTD_A)*100;
ON REGION SUBFOOT
"Total for " "

Try this:
-* File cartotal.fex
DEFINE FILE CAR
CNT/I6 = 1;
PAIDCOST/P17.2CM = RETAIL_COST ;
END
TABLE FILE CAR
PRINT
COUNTRY
MODEL AS 'Model'
PAIDCOST AS 'Retail Cost'
DEALER_COST
CNT NOPRINT
BY COUNTRY AS 'Country'
ON COUNTRY RECAP
COST/P17.2% = PAIDCOST/DEALER_COST;
ON COUNTRY SUBFOOT
"Totals: .lt.COST "
END

ALSO IN STYLESHEET subfoot use headalign as body Run this with grid on initially

See if this works,

Vipul

Your best bet would be to create the report in PDF format. Using PDF will allow use to either position in the stylesheet or use spot markers in the SUBFOOT. Both will allow use to position th totals where you want. Other option might be to use absolute positioning in CSS for HTML.