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,
WF: 7.6.8 OS/Platform: Windows, Unix
June 25, 2012, 06:23 PM
Don Garland
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.
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :
June 26, 2012, 08:46 AM
Neenz
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.