Focal Point
Freeze Panes in HTML?

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

July 27, 2011, 03:18 PM
Jason K.
Freeze Panes in HTML?
Does anyone know if it's possible to keep the headings at the top of an HTML output report, similar to what excel does with "freeze panes"?


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
July 27, 2011, 03:45 PM
dburton
Hey Jason,

This is an easy command. In your style sheet for HTML layout you set an option called HFREEZE. I pasted some sample code.

HFREEZE=ON <-- this is to set both the Header and Footer to freeze.
HFREEZE=TOP or BOTTOM <-- TOP is for the Header and BOTTOM is for the Footer.

     TYPE=REPORT,
     ALIGN-BORDERS=BODY,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     RIGHTGAP=0.027778,
     LEFTGAP=0.027778,
     TOPGAP=0.027778,
     BOTTOMGAP=0.027778,
     LINES-PER-PAGE=20,
     HFREEZE=TOP,
$


Hope this helps.

Dave


WebFOCUS 7.7.03
Windows Web Server 2008
MS SQL Server 2000
Excel,CSV,PDF,HTML
July 27, 2011, 05:40 PM
Rafael.AZ
quote:
HFREEZE=TOP,

wow! Burton, I didnt know that command existed! that was very helpful thanks a lot!


WebFocus 768
Windows, all output
July 27, 2011, 05:41 PM
Jason K.
quote:
HFREEZE=TOP,

This is so cool! Thanks dburton!


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
July 27, 2011, 05:52 PM
Enigma006
This works only for HTML though Smiler


8.1.05
HTML,PDF,EXL2K, Active, All
July 27, 2011, 06:12 PM
Waz
Jason, a quick search of the forum would have shown many other posts about this.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

July 27, 2011, 07:46 PM
Carlos Dias
And for AHTML? Any workaround?

Thanks,
Carlos Dias


WebFOCUS version: 7.6
Linux/Windows
HTML, Excel
July 27, 2011, 07:53 PM
Waz
If HFREEZE does not work, and there is nothing returned from a search, then I would suggest asking techsupport.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

July 27, 2011, 08:08 PM
Enigma006
Only way is to set the number of records on the screen so that scroll does not appear. To go to the next set of records, users can anyway click on arrows and page numbers in AHTML

  
$
TYPE=REPORT,
     LINES-PER-PAGE=15,


Thanks


8.1.05
HTML,PDF,EXL2K, Active, All
July 28, 2011, 04:33 AM
Madasabear
Only works from 7.6.5 onwards although in an early patch of 7.6.5 it didn't work.


Developer Studio Release : 7.6.11