Hello,

I need to subtotal on different BY fields but need the same fields to subtotal on.
On the first BY field, I am subtotalling on 2 fields and on the second BY field I am subtotalling on 4 fields.
When I run the report, the subtotal is shown for all 4 fields for both the BY fields.
When using the GUI, I am selecting show subtotals for only 2 fields, but it is not being respected when the report is run.

The following is the code I am using.

Thanks,

TABLE FILE V_FX_SWAPS_FLAT
PRINT 
     V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.SL_DEAL_NUMBER AS 'Deal,#'
     V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.type AS 'Type'
     V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.trade_dt AS 'Trade,Date'
     V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.vd_yymd AS 'Value,Date'
     V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.slccysold AS 'Buy'
    V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.amount_bght AS 'Principal'
     V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.srate AS 'Spot,Rate'
  V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.SL_CCY_BOUGHT AS 'Against'
     V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.equivsold AS 'Equiv,Sold'
     V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.fwd_dt AS 'Fwrd,Date'
     V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.SL_RATE AS 'Fwrd,Rate'
     V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.term AS 'Term,(Days)'
 V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.remaining_term AS 'Rem,Term'
V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.SL_AMOUNT_BOUGHT AS 'Buy,Amount'
  V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.LL_CCY_BOUGHT AS 'Sell'
    V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.SL_AMT_SOLD AS 'Amount'
     V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.cparty AS 'CParty'
BY  V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.SL_CCY_BOUGHT NOPRINT 
BY  V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.SL_CCY_SOLD NOPRINT 
BY  V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.remaining_term NOPRINT 
     
ON V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.SL_CCY_BOUGHT SUBTOTAL
     'V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.equivsold'
     'V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.SL_AMOUNT_BOUGHT' AS 'Total'
     
ON V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.SL_CCY_SOLD SUBTOTAL
     'V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.amount_bght'
     'V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.equivsold'
     'V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.SL_AMOUNT_BOUGHT'
     'V_FX_SWAPS_FLAT.V_FX_SWAPS_FLAT.SL_AMT_SOLD' AS 'Sub-total for'
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,
$
ENDSTYLE
END
  

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

Try recap and subfoot to handle this situation.

Thanks a lot for the info.
I got it working using subfoot.