I am trying to use HFREEZE to freeze my headings, but my body and headings donot line up.

TABLE FILE PLKHLD
SUM
MEAS0a/D18 AS 'Cost,(Current)'
MEAS0b/D18 AS 'Open Commitments,(Current)'

MEAS01/D18 AS 'Cost+OC,(Current)'
MEAS02/D18 AS 'Cost+OC,(&PLAN_VERSION)'
COMPUTE MEAS03/D18 = MEAS01 - MEAS02; AS 'Delta,(Cost+OC),abs'
COMPUTE DCCV/D21.1% MISSING ON = IF MEAS01 EQ 0 OR MEAS02 EQ 0 OR MEAS03/MEAS02 GT 99 THEN MISSING ELSE (MEAS03 / MEAS02) * 100; AS 'Delta,(Cost+OC),%'
MEAS04/D18 AS 'Plan/FC,(Current)'
MEAS05/D18 AS 'Plan/FC,(&PLAN_VERSION)'
COMPUTE MEAS06/D18 = MEAS04 - MEAS05; AS 'Delta,(Plan/FC),abs'
COMPUTE DACCV/D21.1% MISSING ON = IF MEAS04 EQ 0 OR MEAS05 EQ 0 OR MEAS06/MEAS05 GT 99 THEN MISSING ELSE (MEAS06 / MEAS05) * 100; AS 'Delta,(Plan/FC),%'
BY SORTIER1 AS ' '
BY SORTIER2 AS '&PER_DESC (in &ACTCURR)'
ON SORTIER1 SUBFOOT
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
LEFTMARGIN=0.010000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
$
TYPE=REPORT, HFREEZE=TOP,$
ENDSTYLE
END

Is there something that am missing?

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

Seems to line up ok using car data.

  

-SET &PLAN_VERSION = '2.0';
DEFINE FILE CAR
MEAS0a/D18 = SALES;
MEAS0b/D18 = SALES*2;
MEAS01/D18 = DEALER_COST;
MEAS02/D18 = DEALER_COST*2;
MEAS04/D18 = RETAIL_COST+DEALER_COST;
MEAS05/D18 = RETAIL_COST-DEALER_COST;
SORTIER1/A20 = CAR;
SORTIER2/A20 = CAR;
END

TABLE FILE CAR
SUM
MEAS0a/D18 AS 'Cost,(Current)'
MEAS0b/D18 AS 'Open Commitments,(Current)'

MEAS01/D18 AS 'Cost+OC,(Current)'
MEAS02/D18 AS 'Cost+OC,(&PLAN_VERSION)'
COMPUTE MEAS03/D18 = MEAS01 - MEAS02; AS 'Delta,(Cost+OC),abs'
COMPUTE DCCV/D21.1% MISSING ON = IF MEAS01 EQ 0 OR MEAS02 EQ 0 OR MEAS03/MEAS02 GT 99 THEN MISSING ELSE (MEAS03 / MEAS02) * 100; AS 'Delta,(Cost+OC),%'
MEAS04/D18 AS 'Plan/FC,(Current)'
MEAS05/D18 AS 'Plan/FC,(&PLAN_VERSION)'
COMPUTE MEAS06/D18 = MEAS04 - MEAS05; AS 'Delta,(Plan/FC),abs'
COMPUTE DACCV/D21.1% MISSING ON = IF MEAS04 EQ 0 OR MEAS05 EQ 0 OR MEAS06/MEAS05 GT 99 THEN MISSING ELSE (MEAS06 / MEAS05) * 100; AS 'Delta,(Plan/FC),%'
BY SORTIER1 AS ' '
BY SORTIER2 AS 'Something (Goes Here)'
ON SORTIER1 SUBFOOT
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
LEFTMARGIN=0.010000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
$
TYPE=REPORT, HFREEZE=TOP,$
ENDSTYLE
END

Are you viewing the result in Internet Explorer or a different browser? In my experience HFREEZE columns don't line up properly in standards-compliant browsers.

I am using IE. Even with the car example above my table heading and body is not getting lined up. The header is getting frozen.


http://www.flickr.com/photos/8...44982/in/photostream

I was able to resolve the issue, the fix is to turn WRAP=OFF.

TYPE=REPORT, SQUEEZE=1, WRAP=OFF,$