Focal Point
[SOLVED]Issues with HFREEZE

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1147046126

June 25, 2012, 04:21 PM
Neenz
[SOLVED]Issues with HFREEZE
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




WebFOCUS Administrator @ Worldpay FIS
PROD/DEV/TEST: 8204, SANDBOX: 8206 soon - BIP, Reportcaster, Resource Manager, EUM, HyperStage soon, DB: HIVE,Oracle,MSSQL
June 26, 2012, 07:27 AM
Wep5622
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.


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


WF: 7.6.8
OS/Platform: Windows, Unix
June 26, 2012, 09:23 AM
Neenz
I was able to resolve the issue, the fix is to turn WRAP=OFF.

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


WF: 7.6.8
OS/Platform: Windows, Unix