I have a customer who wants a blank line before the RECOMPUTE/SUBTOTAL in Excel. I thought it would be rather easy but I can't seem to figure out how to do it.

Any ideas would be greatly appreciated.

Try a search on SKIP-LINE to see if that resolves the issue. Often times a "" will add a blank line but not sure if it works for Subtotal or not. It works for Headers...

ERINP
This may be a Possible Answer

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

I apologize for not mentioning what I have tried so far. I tried ON sortfield SKIP-LINE, ON sortfield SUBFOOT, but the SUBTOTAL always comes first and there doesn't seem to be a way to get a blank line before the SUBTOTAL.

Steve

Steve,
What is the output? HTML, Excel, PDF...?? I think you can do this using the ON sortfield SUBFOOT. If you let me know the output I will try to create a car file example for you. I have used this for TOT.sortfield so I would think I can get it to work for a SUB-TOTAL.

ERINP

The output is EXL2K

Steve,
here is a CAR example that seems to work. The fact that I have GRID=OFF may be the reason this works...

  TABLE FILE CAR
SUM
     'CAR.BODY.BODYTYPE'
     'CAR.SPECS.MPG'
     'CAR.BODY.SEATS'
     'CAR.BODY.SALES/P11.2C'
     COMPUTE TOT_SALES/P11.2CM = TOT.SALES; NOPRINT
     COMPUTE TOT_SALE2/P11.2CM = TOT.SALES; NOPRINT
     COMPUTE TOT_SALE3/P11.2CM = TOT.SALES; NOPRINT
BY 'CAR.ORIGIN.COUNTRY'
BY 'CAR.CARREC.MODEL'
-*WHERE COUNTRY = 'ENGLAND';
ON CAR.ORIGIN.COUNTRY SUBFOOT
""
" <+0> <+0> <+0>SUBFOOT1 LINE2 COUNTRY <+0> <ST.CAR.BODY.SALES"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
TYPE=SUBFOOT,
     STYLE=BOLD,
     JUSTIFY=RIGHT,
     HEADALIGN=BODY,
  
$
ENDSTYLE
END