Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Freeze Panes in HTML?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Freeze Panes in HTML?
 Login/Join
 
Master
posted
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.
 
Posts: 611 | Registered: January 04, 2007Report This Post
Gold member
posted Hide Post
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
 
Posts: 71 | Location: Kingston, ON | Registered: May 03, 2011Report This Post
Member
posted Hide Post
quote:
HFREEZE=TOP,

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


WebFocus 768
Windows, all output
 
Posts: 18 | Registered: June 20, 2011Report This Post
Master
posted Hide Post
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.
 
Posts: 611 | Registered: January 04, 2007Report This Post
Master
posted Hide Post
This works only for HTML though Smiler


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
Expert
posted Hide Post
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!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
And for AHTML? Any workaround?

Thanks,
Carlos Dias


WebFOCUS version: 7.6
Linux/Windows
HTML, Excel
 
Posts: 127 | Location: Aveiro, Portugal | Registered: February 04, 2011Report This Post
Expert
posted Hide Post
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!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Master
posted Hide Post
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
 
Posts: 484 | Registered: February 03, 2009Report This Post
Member
posted Hide Post
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
 
Posts: 21 | Location: TataSteel Strip Products UK , Port Talbot , South Wales | Registered: November 28, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Freeze Panes in HTML?

Copyright © 1996-2020 Information Builders