[CLOSED] Lock Vertical Scrolling with Multiple Frames

I attended Summit last week and worked with one of the experts to get a working example on how to freeze a column (not a row) on a very wide report. I'm now back in my own environment and have the example running, but there is an issue with the scrolling. The locked column frame does not scroll up and down with the scrolling frame. So, at first, I can scroll left to right and it looks just fine. However, if you reduce the height of your browser window so that the dataset requires you to scroll down, you will see that the frames do not scroll together. This loses the integrity of the row headers. Any suggestions on how I might be able to lock the vertical scrolling of these two frames?

FILEDEF T1 DISK D:\ibi\WebFOCUS77\webapps\webfocus\T1.HTML
FILEDEF T2 DISK D:\ibi\WebFOCUS77\webapps\webfocus\T2.HTML

SET HTMLCSS = ON

-* Below generates left frame, for 1st column to be used only
TABLE FILE CAR
SUM MODEL BODYTYPE SEATS
BY COUNTRY
ACROSS CAR
ON TABLE HOLD AS T1 FORMAT HTML
ON TABLE SET STYLE *
TYPE=REPORT,GRID=OFF,$
ENDSTYLE
END

-* Below generates right frame, for all columns to be used
TABLE FILE CAR
SUM MODEL BODYTYPE SEATS SALES
BY COUNTRY NOPRINT
ACROSS CAR
ON TABLE HOLD AS T2 FORMAT HTML
ON TABLE SET STYLE *
TYPE=REPORT,GRID=OFF,$
ENDSTYLE
END

-RUN

-HTMLFORM BEGIN
<html>
	<frameset rows="*" cols="110,*" frameborder="NO" border="0" framespacing="0">
		<frame src="T1.HTML" name="leftfr" scrolling="no" noresize>
		<frame src="T2.HTML" name="topfr" scrolling="auto" noresize>
	</frameset>
</html>
-HTMLFORM END

This message has been edited. Last edited by: <Kathryn Henning>,

Posts: 2 | Registered: April 04, 2012

Francis Mariani

Expert

posted

Hide Post

In my opinion the expert shouldn't have used frames to achieve this. Another expert in a different room discouraged one of my colleagues from using frames to display a report on the same browser page (usually done in an iframe, but he was using a frame set. Frames are obsolete in HTML 5 "because using them damages usability and accessibility". We should all be moving toward an HTML 5 world. Instead of frames try divs or, here is a crude but working example using only CSS (based on this Stack Overflow forum thread):

SET PAGE=NOLEAD
SET BYDISPLAY=ON
-RUN

TABLE FILE EMPLOYEE
PRINT
LAST_NAME
FIRST_NAME
HIRE_DATE
DEPARTMENT
CURR_SAL
CURR_JOBCODE
ED_HRS
BANK_NAME
BANK_CODE
BANK_ACCT
EFFECT_DATE
DAT_INC
PCT_INC
SALARY
JOBCODE
JOBCODE
JOB_DESC
SEC_CLEAR
SKILLS
SKILL_DESC

BY EMP_ID

HEADING
"Webfocus Report"

ON TABLE HOLD AS H001 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, GRID=OFF, WRAP=OFF, $
TYPE=TITLE, STYLE=BOLD, COLOR=NAVY, $
TYPE=DATA, COLUMN=EMP_ID, CLASS=headcol, $
TYPE=TITLE, COLUMN=EMP_ID, CLASS=headcol, $
ENDSTYLE
END
-RUN

-HTMLFORM BEGIN

<!DOCTYPE html>
<html>

<head>
  <title>Webfocus Report</title>
  <style type="text/css">
    body {
      font-family: Arial, sans-serif; font-size: 9pt;
      }
    #outerdiv {
      position: absolute;
      top: 0;
      left: 0;
      right: 6em;
      }
    #innerdiv {
      width: 100%;
      overflow-x: scroll;
      margin-left: 6em;
      overflow-y: visible;
      padding-bottom: 1px;
      }
    .headcol {
      position: absolute;
      width: 6em;
      left: 0;
      top: auto;
      color: navy;
      }
  </style>
</head>

<body>
  <div id="outerdiv">
    <div id="innerdiv">

!IBI.FIL.H001;

    </div>
  </div>
</body>
</html>

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

Doug

Expert

posted

Hide Post

Thanks for your insight Francis, especially the "Frames are obsolete in HTML5". We're an IE8 shop...

What's your thoughts on using the <TR> and <TD> tags instead of "divs"?

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

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Show Post

Francis Mariani

Expert

posted

Hide Post

I am a bit disappointed that not all of WebFOCUS 8 is HTML 5 compliant. The new graphing tool generates HTML 5 code is is supposed to be quite impressive. I hope the new Portal tool generates HTML 5 but I don't know. I do know that HTML Composer does not generate HTML 5 code.

The WWW geeks keep talking about moving away from tables, I probably frown upon using tables to layout a web page, though it's sometimes quite a struggle using divs and spans. Meanwhile, WebFOCUS reports are still best represented in tables. I wish some aspects of the WebFOCUS engine would be modernized, for example, it would be nice if

tags were generated for column titles because nice CSS stuff can be used. In general one can use CSS to do a lot with tables.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

[CLOSED] Lock Vertical Scrolling with Multiple Frames

Focal Point | Privacy Statement | Terms of Service