July 17, 2007, 05:54 PM
Francis MarianiSince this seems to be a bug, the only way to fix the problem is a workaround. Try playing with TOPGAP and BOTTOMGAP for the elements that have borders, Column Title and Sub-total, make the top/bottom gaps in the first report different from the second:
DEFINE FILE CAR
UN/A1 = ' ';
G/A1 = ' ';
END
TABLE FILE CAR
COUNT
CAR AS 'CAR COUNT'
BY UN NOPRINT
BY COUNTRY
BY G AS ' '
ON UN SUBTOTAL CAR AS 'TOTAL'
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.1000000,
LEFTMARGIN=0.50,
RIGHTMARGIN=0.50,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='TIMES NEW ROMAN',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.02,
LEFTGAP=0.02,
TOPGAP=0.05,
BOTTOMGAP=0.05,
$
TYPE=DATA,
COLUMN=ACCT_UNIT,
STYLE=BOLD,
$
TYPE=TITLE,
BOTTOMGAP=0.08,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=G(*),
BORDER-BOTTOM=OFF,
SIZE=5,
$
TYPE=SUBTOTAL,
TOPGAP=0.02,
BOTTOMGAP=0.08,
BORDER=LIGHT,
BORDER-COLOR='WHITE',
$
TYPE=SUBTOTAL,
BY=1,
BORDER=LIGHT,
BORDER-COLOR='WHITE',
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N4,
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR='BLACK',
BORDER-BOTTOM=HEAVY,
BORDER-BOTTOM-COLOR='BLACK',
$
TYPE=REPORT,
COLUMN=G(*),
SQUEEZE=OFF,
$
END
DEFINE FILE CAR
UN/A1 = ' ';
G/A1 = ' ';
END
TABLE FILE CAR
SUM
RETAIL_COST
BY UN NOPRINT
BY COUNTRY
BY G AS ' '
ON UN SUBTOTAL RETAIL_COST AS 'TOTAL'
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.1000000,
LEFTMARGIN=0.50,
RIGHTMARGIN=0.50,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='TIMES NEW ROMAN',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.02,
LEFTGAP=0.02,
TOPGAP=0.05,
BOTTOMGAP=0.05,
$
TYPE=DATA,
COLUMN=ACCT_UNIT,
STYLE=BOLD,
$
TYPE=TITLE,
BOTTOMGAP=0.02,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=G(*),
BORDER-BOTTOM=OFF,
SIZE=5,
$
TYPE=SUBTOTAL,
TOPGAP=0.08,
BOTTOMGAP=0.02,
BORDER=LIGHT,
BORDER-COLOR='WHITE',
$
TYPE=SUBTOTAL,
BY=1,
BORDER=LIGHT,
BORDER-COLOR='WHITE',
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N4,
BORDER-TOP=LIGHT,
BORDER-TOP-COLOR='BLACK',
BORDER-BOTTOM=HEAVY,
BORDER-BOTTOM-COLOR='BLACK',
$
TYPE=REPORT,
COLUMN=G(*),
SQUEEZE=OFF,
$
END
Definitely not the definitive answer.