 |
|||||
|
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
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 WebFOCUS/FOCUS Forum on Focal Point [NFR] AHTML - How To Freeze Column Headings?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [NFR] AHTML - How To Freeze Column Headings? Read-Only TopicGo | Search | Notify | Tools |
| [NFR] AHTML - How To Freeze Column Headings? | Login/Join |
| Master |
How can I lock AHTML report column headings in place, so when users scroll down, they do not lose the column headings? My users have found that turning off AHTML paging, and having all data display on one page, very helpful to their analysis. However, losing the column headings, when scrolling down, is problematic. Here is an example of what we are doing using the IB GGSALES sample database:
TABLE FILE GGSALES
HEADING
"Production Orders"
PRINT DOLLARS
UNITS
BY CATEGORY
BY PRODUCT
ON TABLE HOLD AS REPORT1 FORMAT AHTMLTAB
ON TABLE SET STYLE *
TYPE=REPORT,
-* Show all results on one page.
LINES-PER-PAGE=UNLIMITED,
OBJECT=STATUS-AREA,
-* Turn off pagination bar.
PAGE-LOCATION=OFF,$
ENDSTYLE
END
-*
-HTMLFORM BEGIN
<HTML>
<HEAD>
<TITLE>A Scroll Bar, a Scroll Bar, my kingdom for a Scroll Bar.</TITLE>
</HEAD>
<BODY>
!IBI.OBJ.ACTIVEREPORTJS;
!IBI.FIL.REPORT1;
</BODY>
</HTML>
-HTMLFORM ENDThank you all, for your thoughts. 8/11/17 Edits: 1. Removed 'Solved' from thread title. [Not sure why moderator marked it 'Solved'. :-)] 2. Simplified code sample. 8/27/17 Edit: Removed 'Closed' from thread title. :-) 9/01/17 Edit: Removed 'Solved' from thread title. Unless the moderators know something I don't. :-) This message has been edited. Last edited by: David Briars, | ||
|
| Platinum Member |
Hi David, Maybe this will help. I happened to come across it on the tech support site...How to freeze the Heading in an AHTML report. http://techsupport.information...om/sps/62382527.html WebFOCUS 8202 Win 2012 Test - WebFOCUS 8203 on Win 2012 | |||
|
| Master |
Six years/two releases/1,100+ thread views/many hair strands lost later... * new set of users :-) * same problem :-( Does anyone have an idea of how to freeze the report heading/column headings in Active Reports, so that users can scroll down through the data? I can't seem to sell my users on the idea of paging instead of scrolling. In fact, our users may drop Active Reporting, if only because of no scrolling down. I am thinking that the headings and the body sections must be identified/indentifiable. And, if so, there should be some CSS/JS magic that would cause the 'top' section to stay fixed, and the 'body' section to scroll.This message has been edited. Last edited by: David Briars,
| ||||
|
| Expert |
Just a thought to get things started: How about doing two reports in one display? That is:: Report 1: is sort of an empty report which shows only one row of (DEFINEd) empty data using FORMAT HTMTABLE (to get the column titles). Report 2: is a normal report with the column titles "AS ''". Then use the HTMLFORM BEGIN / END.
| |||||
|
| Member |
Maybe I am simplifying this too much. However, did you try to use this stylesheet code for the freeze? TYPE=REPORT, FREEZE-COLUMN=N1, LINES-PER-PAGE=20, $ And for Headings, If you change your Report Heading to a Page Heading by using ON TABLE SUBHEAD "This is my heading" I know it is not exactly the same as Excel. But, I think it gives you what you are looking for. WebFOCUS 8.1.05M Windows, All Outputs | |||
|
| Master |
@Jeff - Nice first post. Welcome to FocalPoint. :-) For wide Active reports the ability to freeze the first n columns is a great feature. We use it on some of our wide AR's and our users love it. In my current scenario, our report isn't necessarily wide (horizontal), as much as it is very long (vertically). I *personally* like the paging option/lines per page you show, and alas, my users do not want pages of data, they want one long page they can scroll down/through. While currently they *can* scroll down, the column heading stuff goes up and out of site, and so they lose context of which column is which.
| ||||
|
| Master |
@Doug - Thank you for the suggestion. I will see if I can play around with the concept. I am not sure how to get the same column widths in each report, as well as, how to 'lock' the first report, and it might be worth playing around with. :-) Thanks again, for the reply.
| ||||
|
| Master |
I thought I would take the sample code and attempt to make the report 'body' section identifiable, and then add CSS code to create a vertical scroll bar. DEFINE FILE GGSALES
DUMMY/A1 = 'A';
DIVISION/A25 = '<tbody><TR><TD>';
EDIVISION/A25 = '</TD></TR></tbody>';
END
-*
TABLE FILE GGSALES
HEADING
"Production Orders"
PRINT SEQ_NO
DOLLARS/I9C
UNITS/I9C
-* Report sorting.
BY DUMMY NOPRINT
ON DUMMY SUBHEAD
"*** Beginning of report body ***"
"<DIVISION>"
ON DUMMY SUBFOOT
"<EDIVISION>"
"*** End of report body ***"
BY CATEGORY
BY PRODUCT
-* Report-wide settings.
ON TABLE PCHOLD AS REPORT1 FORMAT AHTML
ON TABLE SET BYDISPLAY ON
ON TABLE SET STYLE *
INCLUDE=ENDEFLT.STY,$
TYPE=REPORT, LINES-PER-PAGE=UNLIMITED, OBJECT=STATUS-AREA, PAGE-LOCATION=OFF, $
ENDSTYLE
END
-RUN
-*
-HTMLFORM BEGIN
<HTML>
<HEAD>
<TITLE></TITLE>
<style>
tbody:nth-child(1) { display: block; }
tbody:nth-child(2) { display: block; }
tbody:nth-child(2) {
height: 500px;
overflow-y: auto;
}
</style>
</HEAD>
<BODY>
!IBI.FIL.REPORT1;
</BODY>
</HTML>
-HTMLFORM END  Scroll bars control what part of the report you can see, and alas, positioning in the body is lost. Interesting, the Active menu options continue to work. This is about as far as I can/will take this. I mostly wanted to see what might be feasible. If an Active Report geek, can use this as a springboard to a true workaround to share, that would be great. | |||
|
| Expert |
use HFREEZE as copied from the Webfocus Keysheet HFREEZE= sel ....... control heading, title, footing, and total locations during scrolling sel: BOTTOM ............ freeze grand totals and footings sel: OFF ............... [default] no elements frozen sel: ON ............... all elements frozen (headings, titles, footings, grand totals) sel: TOP ............. freeze headings and titles
| |||||
|
| Expert |
I might be wrong, but I thought HFREEZE and Active reporting were not compatible? Essentially because each one is JavaScript driven and "does things"  to the DOM that would screw up what the other option has done?T
| |||||||||
|
| Master |
My understanding of the 'Creating Reports' manual (8105M) is that the HFREEZE StyleSheet attribute is available for HTML report, and not Active Reports.
| ||||
|
| Platinum Member |
Just add the following line to the FEX SET HFREEZE ON or maybe SET HFREEZE=ON Release 7.6.9 Windows HTML | |||
|
| Platinum Member |
An easier way is to put the HFREEZE into the Style Sheet area.. TYPE=REPORT,HFREEZE=ON,$ Release 7.6.9 Windows HTML | |||
|
| Virtuoso |
David You are getting advice directly from the top! GCohen is Gerry Cohen owner and founder. That is awesome!!! Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Virtuoso |
David After checking with product management currently is only supported for active reports on Mobile devices when in Fullscreen view. In order to do this the way you want a new feature request will have to be submitted via a case with techsupport. Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Master |
Thank you Chuck. I'll have my colleague transition our case to a NFR. | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [NFR] AHTML - How To Freeze Column Headings?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [NFR] AHTML - How To Freeze Column Headings?Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |