Focal Point
Freeze Panes in HTML?
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
dburtonHey 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.AZquote:
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
Enigma006This works only for HTML though
8.1.05
HTML,PDF,EXL2K, Active, All
July 27, 2011, 06:12 PM
WazJason, a quick search of the forum would have shown many other posts about this.
Waz...Prod: | WebFOCUS 7.6.10/8.1.04 | Upgrade: | WebFOCUS 8.2.07 | OS: | Linux |
Outputs: | HTML, PDF, Excel, PPT |
In Focus since 1984 |
Pity the lost knowledge of an old programmer! |
July 27, 2011, 07:46 PM
Carlos DiasAnd for AHTML? Any workaround?
Thanks,
Carlos Dias
WebFOCUS version: 7.6
Linux/Windows
HTML, Excel
July 27, 2011, 07:53 PM
WazIf 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.04 | Upgrade: | WebFOCUS 8.2.07 | OS: | Linux |
Outputs: | HTML, PDF, Excel, PPT |
In Focus since 1984 |
Pity the lost knowledge of an old programmer! |
July 27, 2011, 08:08 PM
Enigma006Only 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
MadasabearOnly 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