Hi All,

Has anyone successfully been able to load a table that uses HFREEZE to create static headers and footers into a < div > containter on a separate HTML page?

I did a test with a small table and simple web page containing one div. I can load it into the div via an Ajax call to the fex which returns the HTML string, which I then load into the div with innerHTML. It loads nicely but the fixed headers/footers are completely removed. I assume it has something to do with the IB javascript libraries or the unique ID of the div that IB writes into the output. I have also experimented by adding the IB javascript files into my page but with no success.

More and more users are wanting the fixed headers and footers and I can appreciate the utility of this but I can't make it work in an external HTML page. I find it easier and cleaner to code web pages and then load the fex output into them - without using the HTML layout tool. I just think that IB's HTML layout tool adds too much crap to the file and it's a mess for me to understand and deal with.

Thanks,

Norb

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

H is FREEZEing over!

HFREEZE -- Titles Not Matching Listing

We seem to be having trouble using HFREEZE on anything but a standard, simple report.

I may resort to using non-WebFOCUS techniques to solve this.

To use HFREEZE effectively, you need to HEADALIGN=BODY in your style. We still use HTML code with anchors and class/css attributes:

  
 ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='SCREEN',
     LEFTMARGIN=0.000000,
     RIGHTMARGIN=0.000000,
     TOPMARGIN=0.000000,
     BOTTOMMARGIN=0.000000,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=ON,
     FONT='ARIAL',
     SIZE=8,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
     RIGHTGAP=0.000,
     TOPGAP=0.0,
     BOTTOMGAP=0.0,
	 TITLETEXT='State Funds Expense - &XMO',
$
TYPE=DATA,
     GRID=ON,
	 BORDER=LIGHT,
     TOPGAP=0.035555,
     BOTTOMGAP=0.022222,
$
-SET &LEN=&DEPT.LENGTH ;
-SET &FMT='A' | &LEN.EVAL ;
-SET &DEPT1= CTRAN(&LEN, &DEPT, 39, 42, '&FMT');
TYPE=REPORT,
    IMAGE=app/excel.jpg,
    POSITION=(0.1500 0.135000),
    SIZE=(0.250000 0.250000),
    FOCEXEC=app/otp_html.fex (FY = &FY FP = &FP RANDOM = &RANDOM DEPT = '&DEPT1' OUTPUT = 'EXL2K'),
	TARGET='_blank',
	ALT='Output Report to EXCEL',
	CLASS=anchor headsty3,
$
TYPE=DATA, COLUMN=N11,
    FOCEXEC=app/otp_drill1.fex ( \
-GOTO HERE
     IBIMR_action='MR_RUN_FEX' \
     IBIMR_sub_action='MR_STD_REPORT' \
     IBIMR_domain='financey/financey.htm' \
     IBIMR_folder='#tflynnjqazhm'  \
     IBIC_server='EDASERVE' \
     IBIMR_fex='app/otp_drl1.fex' \
     IBIF_ex='app/otp_drl1.fex' \
     IBIMR_random= &RANDOM \
     IBIF_webapp='' \
     IBIMR_drill='x,financey/financey.htm' \
-HERE
     XFUND = N20 \
	 PGM = X_PGM \
	 LEVEL4 = N21 \
	 FY = &FY \
	 FP = &FP \
	 DRILL = '1' \
	 XPOOL = ' ' \
	 DEPT = '&DEPT1'),
     TARGET='_blank',
	 ALT='Drilldown to Fund Summary',
WHEN=X_TOTAL NE 0,
$
TYPE=HEADING,
	STYLE=BOLD,
	SIZE=9,
	JUSTIFY=LEFT,
	HEADALIGN=BODY,
$
TYPE=HEADING,
	LINE=1,
	ITEM=1,
	COLSPAN=10,
	JUSTIFY=CENTER,
    CLASS=anchor headsty1,
$
TYPE=HEADING,
	LINE=2,
	ITEM=1,
	JUSTIFY=LEFT,
	COLSPAN=1,
    CLASS=anchor headsty2a,
$
TYPE=HEADING,
	LINE=2,
	ITEM=2,
	JUSTIFY=CENTER,
	COLSPAN=7,
    CLASS=anchor headsty2,
$
TYPE=HEADING,
	LINE=2,
	ITEM=3,
	JUSTIFY=RIGHT,
	COLSPAN=2,
	SIZE=10,
	BORDER=LIGHT,
    CLASS=anchor headsty2b,
$
TYPE=HEADING,
	LINE=3,
	ITEM=1,
	JUSTIFY=LEFT,
	COLSPAN=1,
	SIZE=10,
	STYLE=BOLD,
	BORDER=ON,
    CLASS=anchor headsty2,
$
TYPE=HEADING,
	LINE=3,
	ITEM=2,
	JUSTIFY=LEFT,
	COLSPAN=1,
	SIZE=10,
	STYLE=BOLD,
	BORDER=ON,
    CLASS=anchor headsty2,
$
TYPE=HEADING,
	LINE=3,
	ITEM=3,
	JUSTIFY=RIGHT,
	COLSPAN=1,
	SIZE=10,
	STYLE=BOLD,
	BORDER=ON,
    CLASS=anchor headsty2,
$
TYPE=HEADING,
	LINE=3,
	ITEM=4,
	JUSTIFY=RIGHT,
	COLSPAN=1,
	SIZE=10,
	STYLE=BOLD,
	BORDER=ON,
    CLASS=anchor headsty2,
$
TYPE=HEADING,
	LINE=3,
	ITEM=5,
	JUSTIFY=RIGHT,
	COLSPAN=1,
	SIZE=10,
	STYLE=BOLD,
	BORDER=ON,
    CLASS=anchor headsty2,
$
TYPE=HEADING,
	LINE=3,
	ITEM=6,
	JUSTIFY=RIGHT,
	COLSPAN=1,
	SIZE=10,
	STYLE=BOLD,
	BORDER=ON,
    CLASS=anchor headsty2,
$
TYPE=HEADING,
	LINE=3,
	ITEM=7,
	JUSTIFY=RIGHT,
	COLSPAN=1,
	SIZE=10,
	STYLE=BOLD,
	BORDER=ON,
    CLASS=anchor headsty2,
$
TYPE=HEADING,
	LINE=3,
	ITEM=8,
	JUSTIFY=RIGHT,
	COLSPAN=1,
	SIZE=10,
	STYLE=BOLD,
	BORDER=ON,
    CLASS=anchor headsty2,
$
TYPE=HEADING,
	LINE=3,
	ITEM=9,
	JUSTIFY=RIGHT,
	COLSPAN=1,
	SIZE=10,
	STYLE=BOLD,
	BORDER=ON,
    CLASS=anchor headsty2,
$
TYPE=HEADING,
	LINE=3,
	ITEM=10,
	JUSTIFY=RIGHT,
	COLSPAN=1,
	SIZE=10,
	STYLE=BOLD,
	BORDER=ON,
    CLASS=anchor headsty2,
$
-SKIP_HEAD1
TYPE=TITLE,
	STYLE=BOLD,
	SIZE=9,
	JUSTIFY=CENTER,
    CLASS=anchor titlesty,
$
-*TYPE=TITLE,
-*    COLUMN=N12,
-*	JUSTIFY=CENTER,
-*$
-*TYPE=TITLE,
-*    COLUMN=N16,
-*	JUSTIFY=CENTER,
-*$
TYPE=DATA,
	 STYLE=BOLD,
$
TYPE=DATA,
	BACKCOLOR=RGB(204 255 204),
	WHEN=N6 EQ 'Reserve',
$
TYPE=DATA,
	BACKCOLOR=RGB(204 255 204),
	WHEN=N6 EQ 'Payroll',
$
-*TYPE=DATA,
-*    COLUMN=N12,
-*    BACKCOLOR=RGB(204 255 204),
-*    WHEN=N6 EQ 'Reserve',
-*$
TYPE=DATA,
    COLUMN=N12,
	BACKCOLOR=RGB(204 255 204),
	WHEN=X_LEVEL_4 EQ 'AAAA',
$
TYPE=DATA,
    COLUMN=N12,
	BACKCOLOR=RGB(204 255 204),
	WHEN=X_LEVEL_4 EQ 'BBBB',
$
TYPE=DATA,
    COLUMN=N13,
	BACKCOLOR=RGB(204 255 204),
	WHEN=X_LEVEL_4 EQ 'AAAA',
$
TYPE=DATA,
    COLUMN=N13,
	BACKCOLOR=RGB(204 255 204),
	WHEN=X_LEVEL_4 EQ 'BBBB',
$
TYPE=DATA,
    COLUMN=N16,
	BACKCOLOR=RGB(204 255 204),
	WHEN=X_LEVEL_4 EQ 'AAAA',
$
TYPE=DATA,
    COLUMN=N16,
	BACKCOLOR=RGB(204 255 204),
	WHEN=X_LEVEL_4 EQ 'BBBB',
$
TYPE=DATA,
    COLUMN=N18,
	BACKCOLOR=RGB(204 255 204),
	WHEN=X_LEVEL_4 EQ 'AAAA',
$
TYPE=DATA,
    COLUMN=N18,
	BACKCOLOR=RGB(204 255 204),
	WHEN=X_LEVEL_4 EQ 'BBBB',
$
TYPE=DATA,
    COLUMN=N19,
	BACKCOLOR=RGB(204 255 204),
	WHEN=X_LEVEL_4 EQ 'AAAA',
$
TYPE=DATA,
    COLUMN=N19,
	BACKCOLOR=RGB(204 255 204),
	WHEN=X_LEVEL_4 EQ 'BBBB',
$
TYPE=DATA,
    COLUMN=N6,
	COLOR=NAVY,
	STYLE=BOLD,
	SIZE=9,
$
TYPE=DATA,
    COLUMN=D_BUDGET,
	COLOR=RED,
	STYLE=BOLD,
	WHEN=BUD_FLAG EQ 'Y',
$
TYPE=DATA,
    COLUMN=YTD_B,
	COLOR=RED,
	STYLE=BOLD,
	WHEN=YTD_FLAG EQ 'Y',
$
TYPE=DATA,
    COLUMN=D_YTDACT1,
	COLOR=RED,
	STYLE=BOLD,
	WHEN=ACT_FLAG1 EQ 'Y',
$
TYPE=DATA,
    COLUMN=D_YTDACT2,
	COLOR=RED,
	STYLE=BOLD,
	WHEN=ACT_FLAG2 EQ 'Y',
$
TYPE=DATA,
    COLUMN=D_BBA,
	COLOR=RED,
	STYLE=BOLD,
	WHEN=BBA_FLAG EQ 'Y',
$
TYPE=DATA,
    COLUMN=DELTA1,
	COLOR=RED,
	STYLE=BOLD,
	WHEN=DLT_FLAG EQ 'Y',
$
TYPE=SUBFOOT,
    HEADALIGN=BODY,
	STYLE=BOLD,
	JUSTIFY=RIGHT,
$
-*    GOLD
TYPE=SUBFOOT,
    BY=1,
    LINE=2,
	CLASS=border_sf3,
	BACKCOLOR=RGB(255 255 153),
$
-*    GREEN
TYPE=SUBFOOT,
    BY=6,
    LINE=1,
    BACKCOLOR=RGB(204 255 204),
	STYLE=BOLD,
	CLASS=border_sf1,
	WHEN=X_CNTR1 NE 1,
$
TYPE=SUBFOOT,
    BY=6,
    ITEM=3,
    LINE=1,
	BACKCOLOR=RGB(204 255 204),
	STYLE=BOLD,
	COLOR=RED,
	CLASS=border_sf2,
	WHEN=Y_BUDGET1 LT 0,
$
TYPE=SUBFOOT,
    BY=6,
    ITEM=4,
    LINE=1,
	BACKCOLOR=RGB(204 255 204),
	STYLE=BOLD,
	COLOR=RED,
	CLASS=border_sf2,
	WHEN=Y_YTD1 LT 0,
$
TYPE=SUBFOOT,
    BY=6,
    ITEM=5,
    LINE=1,
	BACKCOLOR=RGB(204 255 204),
	STYLE=BOLD,
	COLOR=RED,
	CLASS=border_sf2,
	WHEN=Y_ENC1 LT 0,
$
TYPE=SUBFOOT,
    BY=6,
    ITEM=6,
    LINE=1,
	BACKCOLOR=RGB(204 255 204),
	STYLE=BOLD,
	COLOR=RED,
	CLASS=border_sf2,
	WHEN=Y_RES1 LT 0,
$
TYPE=SUBFOOT,
    BY=6,
    ITEM=7,
    LINE=1,
	BACKCOLOR=RGB(204 255 204),
	STYLE=BOLD,
	COLOR=RED,
	CLASS=border_sf2,
	WHEN=Y_BBA1 LT 0,
$
TYPE=SUBFOOT,
    BY=6,
    ITEM=8,
    LINE=1,
	BACKCOLOR=RGB(204 255 204),
	STYLE=BOLD,
	COLOR=RED,
	CLASS=border_sf2,
	WHEN=Y_YTD2 LT 0,
$
TYPE=SUBFOOT,
    BY=6,
    ITEM=9,
    LINE=1,
	BACKCOLOR=RGB(204 255 204),
	STYLE=BOLD,
	COLOR=RED,
	CLASS=border_sf2,
	WHEN=Y_ACT1 LT 0,
$
TYPE=SUBFOOT,
    BY=6,
    ITEM=10,
    LINE=1,
	BACKCOLOR=RGB(204 255 204),
	STYLE=BOLD,
	COLOR=RED,
	CLASS=border_sf2,
	WHEN=Y_DLT1 LT 0,
$
-*LINE 1 ON DEPARTMENT END
-*"<T_PGM><<<<<<"
TYPE=SUBFOOT,
    BY=1,
    ITEM=3,
    LINE=2,
	CLASS=border_sf4,
	COLOR=RED,
	STYLE=BOLD,
	BACKCOLOR=RGB(255 255 153),
	WHEN=X_BUDGET1 LT 0,
$
TYPE=SUBFOOT,
    BY=1,
    ITEM=4,
    LINE=2,
	CLASS=border_sf4,
	COLOR=RED,
	STYLE=BOLD,
	BACKCOLOR=RGB(255 255 153),
	WHEN=X_YTD1 LT 0,
$
TYPE=SUBFOOT,
    BY=1,
    ITEM=5,
    LINE=2,
	CLASS=border_sf4,
	COLOR=RED,
	STYLE=BOLD,
	BACKCOLOR=RGB(255 255 153),
	WHEN=X_ENC1 LT 0,
$
TYPE=SUBFOOT,
    BY=1,
    ITEM=6,
    LINE=2,
	CLASS=border_sf4,
	COLOR=RED,
	STYLE=BOLD,
	BACKCOLOR=RGB(255 255 153),
	WHEN=X_RES1 LT 0,
$
TYPE=SUBFOOT,
    BY=1,
    ITEM=7,
    LINE=2,
	CLASS=border_sf4,
	COLOR=RED,
	STYLE=BOLD,
	BACKCOLOR=RGB(255 255 153),
	WHEN=X_BBA1 LT 0,
$
TYPE=SUBFOOT,
    BY=1,
    ITEM=8,
    LINE=2,
	CLASS=border_sf4,
	COLOR=RED,
	STYLE=BOLD,
	BACKCOLOR=RGB(255 255 153),
	WHEN=X_YTD2 LT 0,
$
TYPE=SUBFOOT,
    BY=1,
    ITEM=9,
    LINE=2,
	CLASS=border_sf4,
	COLOR=RED,
	STYLE=BOLD,
	BACKCOLOR=RGB(255 255 153),
	WHEN=X_ACT1 LT 0,
$
TYPE=SUBFOOT,
    BY=1,
    ITEM=10,
    LINE=2,
	CLASS=border_sf4,
	COLOR=RED,
	STYLE=BOLD,
	BACKCOLOR=RGB(255 255 153),
	WHEN=X_DLT1 LT 0,
$
-GRAND_TOTAL
TYPE=GRANDTOTAL,
    STYLE=BOLD,
	BACKCOLOR=RGB(135 206 250),
	JUSTIFY=RIGHT,
	BORDER=MEDIUM,
$
TYPE=GRANDTOTAL,
    COLUMN=N6,
	JUSTIFY=CENTER,
	SIZE=9,
$
TYPE=GRANDTOTAL,
    COLUMN=N12,
    COLOR=RED,
	WHEN=D_BUDGET LT 0,
$
TYPE=GRANDTOTAL,
    COLUMN=N13,
    COLOR=RED,
	WHEN=D_YTDACT1 LT 0,
$
TYPE=GRANDTOTAL,
    COLUMN=N14,
    COLOR=RED,
	WHEN=SUM_ENCUMBRANCES LT 0,
$
TYPE=GRANDTOTAL,
    COLUMN=N15,
    COLOR=RED,
	WHEN=SUM_BUDGET_RESERVATION LT 0,
$
TYPE=GRANDTOTAL,
    COLUMN=N16,
    COLOR=RED,
	WHEN=D_BBA LT 0,
$
TYPE=GRANDTOTAL,
    COLUMN=N17,
    COLOR=RED,
	WHEN= LT 0,
$
TYPE=GRANDTOTAL,
    COLUMN=N18,
    COLOR=RED,
	WHEN=D_YTDACT2 LT 0,
$
TYPE=GRANDTOTAL,
    COLUMN=N19,
    COLOR=RED,
	WHEN=DELTA1 LT 0,
$
END
-RUN
-IF &LINES EQ 0 GOTO NO_RECORDS;
-*GOTO EOJ
-*SET HTMLFORMTYPE = XLS
-HTMLFORM BEGIN
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"  "http://www.w3.org/TR/html4/loose.dtd">
<html>
<meta http-equiv="Pragma" content="no-cache">
<style type="text/css">
  a:link     { color: blue; }
  a:visited  { color: blue; }
  a:hover    { color: red; }
.contstyle
{
   border: 2;
   height: 600px;
   width: 1225px;
   overflow: auto;
   font-weight: bold;
   font-size: 10pt;
   color: black;
   background-color: white;
   border: on;
   z-index: 30;
}
.anchor
{
   position: relative;
}
.headsty1
{
	top: -40px;
    font-weight: bold;
    font-size: 12pt;
    border-top: solid blue;
    border-right: solid blue;
    border-bottom: solid blue;
    border-left: solid blue;
	text-align: center;
}
.headsty2
{
	top: -37px;
    border-top:  solid black;
    border-right: thin solid black;
    border-bottom: thin solid black;
    border-left: thin solid black;
	text-align: center;
    color: white;
    background-color: RGB(65 105 225);
}
.headsty2a
{
	top: -37px;
    border-top:  solid black;
    border-right: thin solid black;
    border-bottom: thin solid black;
    border-left: thin solid black;
	text-align: left;
    color: white;
    background-color: RGB(65 105 225);
}
.headsty2b
{
	top: -37px;
    border-top:  solid black;
    border-right: thin solid black;
    border-bottom: thin solid black;
    border-left: thin solid black;
	text-align: right;
    color: white;
    background-color: RGB(65 105 225);
}
.headsty3
{
	top: -40px;
    border-top: solid black;
    border-right: solid black;
    border-bottom: solid black;
    border-left: solid black;
    background-color: white;
}
-**************GREEN
.border_sf1
{
border-top:solid black;
border-left:solid black;
border-right:solid black;
border-bottom: thin solid black;
border-width:1px;
font-size : 8pt;
font-weight: bold;
text-align: right;
background-color: RGB(204 255 204);
z-index: 20;
}
-**************GREEN with NEGATIVES in RED
.border_sf2
{
border-top:solid black;
border-left:solid black;
border-right:solid black;
border-bottom: thin solid black;
border-width:1px;
font-size : 8pt;
font-weight: bold;
text-align: right;
color: red;
background-color: RGB(204 255 204);
z-index: 20;
}
-**************GOLD
.border_sf3
{
border-top:solid black;
border-left:solid black;
border-right:solid black;
border-bottom: thin solid black;
border-width:1px;
font-size : 8pt;
font-weight: bold;
text-align: right;
background-color: RGB(255 255 153);
z-index: 20;
}
-**************GOLD with NEGATIVES in RED
.border_sf4
{
border-top:solid black;
border-left:solid black;
border-right:solid black;
border-bottom: thin solid black;
border-width:1px;
font-size : 8pt;
font-weight: bold;
text-align: right;
color: red;
background-color: RGB(255 255 153);
z-index: 20;
}
</style>
<BODY>
<br>
<br>
<div CLASS="contstyle">
!IBI.FIL.RPT1;
</div>
</BODY>
</html>
-HTMLFORM END
-**********************
-GOTO EOJ
-**********************
-NO_RECORDS
-SET &MSG = 'No Data is available for your selection. <BR>  The Department List is for State Funds, Expense AND Revenue';
-SET &MSG = &MSG | '<BR> You may have selected a Department that has data for Expense only, for example. <BR>  Please close this page and try again.';
-HTMLFORM BEGIN
<HTML>
<head>
</head>
<body style="margin: 0; padding: 0;" aligh="center">
<table border=0 width="90%" height="100%" cellspacing="0" cellpadding="0" >
<tr>
<td  height="23" style="border: 1px solid navy;" bgcolor="navy"   align="center">
<font color="white" size="2" face="verdana">[b]!IBI.AMP.RTITLE; [/b]</font>
</td>
</tr>
<tr>
<td style="border: 1px solid navy;" align="center">
<font  size="2" face="verdana">!IBI.AMP.MSG; </font>
</td>
</tr>
</table>
</body>
</HTML>
-HTMLFORM END
-EOJ
-EXIT

hth

Hi Francis,

I DID try using non-webfocus techniques to generate a separate table header, table grid body to display the data, and table footer. Then I load these into 3 individual divs with the table grid div's overflow set to auto. Works pretty well but maintaining it when you have dynamic columns, (i.e. a changing number of columns between report calls) is a complete "pain in the arse" as Tony A. would say.

Plus when the tables get wide and run off a normal screen you can't sync the horizontal scrolling of the header, body, and footer. Why does this have to be so hard!!!!!!

Hi Tom,

Thanks for your reply and code. I have a web page that contains my parameter selections and calling the fex via Ajax, returning the HTML output as text, and loading the div on the web page directly. I'm not using the HTMLFORM part in the fex. That's probably why it's not working for me.

Your code builds a web page inside of the fex. I've done this lots but got tired of the page reloading all the time and also had a tough time using timers to run the fex at periodic intervals. The timers only worked well with a unique HTML page which called the fex.

Norb

Hi Norb,

OK, just showing it is possible, and, you are doing it another way. Still the anchor concept within the style/css tags "may" be what is needed to be added.

Sounds great, what you are doing, btw!!

Good Luck!

Thanks Tom - I need all the help I can get.

BTW - I don't believe in luck. Everything happens for a reason as there are no coincidences in our lives. But that's just me.

Norb

Best wishes!