[CLOSED] Enable freze in HTML reports

February 27, 2010, 05:14 AM

Hi,
I am using webfocus 769 version to generate my tabular report.
I want to freeze the heading, so that when the user scroll down to see data, the heading will remain visible.
I am able to accomplish this in HTML format, but not in HTMTABLE. Is there any option I can accomplish this in HTMTABLE.

-* HTML Tool
-* Created by Report Assistant
-* FF Line do not change this line! Field Name
-* FF Line do not change this line! Alias
-* FF Line do not change this line! Format
-* FF Line do not change this line! Segment
-* FF Line do not change this line! displayTree=0
TABLE FILE GGSALES
PRINT 
GGSALES.SALES01.CATEGORY
GGSALES.SALES01.CITY
GGSALES.SALES01.DATE
GGSALES.SALES01.PRODUCT
GGSALES.SALES01.REGION
ON TABLE SET STYLE *
TYPE=REPORT,
   GRID=OFF,
HFREEZE = ON,
$
ENDSTYLE
ON TABLE HOLD AS H1 FORMAT HTMTABLE
ON TABLE NOTOTAL
END

-HTMLFORM BEGIN
< !--OMNI_WF_RETURN_CODE:0 -->

<table cellspacing="0" cellpadding="0" border="0" width="100%" >
   <tr >
     <td>
      <hr class="wferrchartline" / >
     </td>
   </tr>
  <tr>
	<td>	
< !-- WEBFOCUS TABLE H1>
	</td>
  </tr>
</table>
-HTMLFORM END
-* End Report Assistant

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

February 27, 2010, 06:08 AM

FrankDutch

Priya

I am sure you have asked this before...
And I am also sure it is possible to get this done, but maybe you should not do it this way.

Just create one or more reports. do NOT use HTMTABLE but just HTML.

Then create an compound HTML report and include the basis reports you want to show.
That is it....

But please do not start a second question, since you did not react on the first one...it is a but confusing this way

February 27, 2010, 06:09 AM

Ram Prasad E

Priya,
Try

ON TABLE SET HTMLCSS ON

Use APP HOLD and check the saved H1 file. To freeze Headers, it should be enclosed within frame tags. If not then use two different HTMTABLEs. One for Header and the other for data.

February 27, 2010, 06:22 AM

Ram Prasad E

Frank mentioned about this post.

http://forums.informationbuild...71057331/m/489109173

February 27, 2010, 06:31 AM

FrankDutch

Ram

yes it is...now I see it is not the same person, but sometimes I get the idea that there is a kind of competition running, where several people want to find out the same solution.
If it is, I think it also is a wast of time for this forum
We all want to help you, but if it is a game, we should get the benefit for it also....

March 01, 2010, 02:54 AM

<JG>

A simple search on the forum would have found the post.
A simple search of the documentation would have found

quote:
The output format for the report must be HTML.

which is what the post says

March 01, 2010, 04:35 AM

Dan Satchell

You could try this and see if it works in your environment. HFREEZE seems to work with HTMTABLE at least as far as producing a scrollable report. But the problem I encounter is that the column titles do not align with the data columns. However, by adding a few lines to the HTMLFORM, stolen from the working HTML version, I was able to get the column titles to align correctly. Specifically, I found that a couple of JavaScript statements and an ONLOAD parameter in the BODY tag were required to produce the desired results.

TABLE FILE CAR
 PRINT BODYTYPE  AS 'Body,Type'
 BY COUNTRY      AS 'Country'
 BY CAR          AS 'Car'
 BY MODEL        AS 'Model'
 ON TABLE SET PAGE-NUM OFF
 ON TABLE SET BYDISPLAY ON
 ON TABLE NOTOTAL
-* ON TABLE PCHOLD FORMAT HTML
 ON TABLE HOLD FORMAT HTMTABLE
 ON TABLE SET HTMLCSS ON
 ON TABLE SET STYLE *
  TYPE=REPORT, HFREEZE=ON, $
 ENDSTYLE
END
-*
-RUN
-HTMLFORM BEGIN
<HTML>
<script language='javascript'>
var ibiOptions = new Array("hfreeze");
</script>
<script language='javascript' src='/ibi_html/javaassist/ibi/html/js/ibigbl.js'></script>
<BODY ONLOAD='ibigblOnLoad();'>
!IBI.FIL.HOLD;
</BODY>
</HTML>
-HTMLFORM END

This message has been edited. Last edited by: Dan Satchell,

March 01, 2010, 05:06 AM

<JG>

Dan, you are quite correct that by including the required javascript into the HTML it will deliver the output
in the same way as several other features that use generated scripts for control.

However it is unsupported funtionality so do not expect IB support to resolve any issues.

March 01, 2010, 08:45 AM

FrankDutch

if you create an HTML report that looks like this

<!-- Generated by Report Layout Painter -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Gen 3.0">
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>

<SCRIPT id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";

var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";

var ibixmltree="ibixmltree";

var ibiOptions = new Array(cgipath,ibirls);
</SCRIPT>

<SCRIPT id=IBI_nls type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT>

<SCRIPT id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js"></SCRIPT>

<SCRIPT id=IBI_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>

<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");
</SCRIPT>
<TITLE>HtmlPage</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {

UpdateData();

// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
</SCRIPT>

<SCRIPT for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>

<META name=GENERATOR content="MSHTML 8.00.6001.18876"></HEAD>
<BODY style="OVERFLOW: auto" elementtype="21" edaconnectionrequired="true">
<IFRAME style="Z-INDEX: 1; POSITION: absolute; WIDTH: 530px; HEIGHT: 220px; OVERFLOW: auto; TOP: 80px; LEFT: 60px" id=report1 title=car1.fex tabIndex=1 src="" frameBorder=no elementtype="2" HEIGHTOLD="330" WIDTHOLD="530" requests_list="0" autoExecute="True" name="report1"></IFRAME>
<IFRAME style="Z-INDEX: 2; POSITION: absolute; WIDTH: 710px; HEIGHT: 240px; OVERFLOW: auto; TOP: 320px; LEFT: 60px" id=report2 title=car11.fex tabIndex=2 src="" frameBorder=no elementtype="2" HEIGHTOLD="290" WIDTHOLD="520" requests_list="1" autoExecute="True" name="report2"></IFRAME>
<SPAN style="Z-INDEX: 3; POSITION: absolute; WIDTH: 570px; HEIGHT: 30px; TOP: 20px; LEFT: 50px" id=text1 tabIndex=3>demo report with multple fixed headers</SPAN>
<SPAN style="Z-INDEX: 4; POSITION: absolute; BACKGROUND-COLOR: black; WIDTH: 650px; HEIGHT: 8px; FONT-SIZE: 1pt; TOP: 60px; LEFT: 40px" id=line2 tabIndex=4 elementtype="5"></SPAN>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value="focalpoint ibisamp ibincces baseapp" type=hidden name="ibiapp_app">
<xml id=focus_xmlelement>
<script type="text/xml">
<rootxmlnode>
<variables></variables>
<input_controls></input_controls>
<other_bound_objects></other_bound_objects>
<requests nextrequestsid="1">
<request requestid="0" targettype="iframe" targetname="report1" sourcetype="typeFex" ibif_ex="car1.fex" ibiapp_app="focalpoint ibisamp ibincces baseapp" activereport="0"></request>
<request requestid="1" targettype="iframe" targetname="report2" sourcetype="typeFex" ibif_ex="car11.fex" ibiapp_app="focalpoint ibisamp ibincces baseapp" activereport="0"></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>

and for the two sub reports

-* File car1.fex
TABLE FILE CAR
PRINT
     LENGTH
BY COUNTRY
BY CAR
BY BODYTYPE
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=CM,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
     HFREEZE=ON,
     SCROLLHEIGHT=1.975309,
$
TYPE=DATA,
     ACROSSCOLUMN=N1,
     BACKCOLOR=( 'WHITE' RGB(225 225 255) ),
$
TYPE=TITLE,
     COLOR=RGB(22 47 97),
     STYLE=BOLD,
$
TYPE=TABHEADING,
     COLOR=RGB(22 47 97),
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     COLOR=RGB(22 47 97),
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     COLOR=RGB(237 241 213),
     BACKCOLOR=RGB(22 47 97),
     STYLE=BOLD,
$
TYPE=FOOTING,
     COLOR=RGB(237 241 213),
     BACKCOLOR=RGB(22 47 97),
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=12,
     COLOR=RGB(22 47 97),
     BACKCOLOR=RGB(225 225 255),
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR='WHITE',
     STYLE=BOLD,
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     COLOR=RGB(22 47 97),
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     STYLE=BOLD,
$
ENDSTYLE
END

and report 2

-* File car11.fex
TABLE FILE CAR
PRINT
     DEALER_COST
     RETAIL_COST
     SALES
BY CAR
BY BODYTYPE
BY COUNTRY

ON CAR SUBTOTAL AS '*TOTAL'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=CM,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
     GRAPHTYPE=DATA,
     COLUMN=N6,
     GRAPHCOLOR='GREEN',
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
     HFREEZE=ON,
     SCROLLHEIGHT=2.469136,
$
TYPE=DATA,
     ACROSSCOLUMN=N1,
     BACKCOLOR=( 'WHITE' RGB(225 225 255) ),
$
TYPE=TITLE,
     COLOR=RGB(22 47 97),
     STYLE=BOLD,
$
TYPE=TABHEADING,
     COLOR=RGB(22 47 97),
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     COLOR=RGB(22 47 97),
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     COLOR=RGB(237 241 213),
     BACKCOLOR=RGB(22 47 97),
     STYLE=BOLD,
$
TYPE=FOOTING,
     COLOR=RGB(237 241 213),
     BACKCOLOR=RGB(22 47 97),
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=12,
     COLOR=RGB(22 47 97),
     BACKCOLOR=RGB(225 225 255),
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR='WHITE',
     STYLE=BOLD,
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     COLOR=RGB(22 47 97),
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     STYLE=BOLD,
$
ENDSTYLE
END

Now you have a HTML report with the frozen headers

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7