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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Freeze column headings (and row titles) in HTML output????
Page 1 2 

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Freeze column headings (and row titles) in HTML output????
 Login/Join
 
Platinum Member
posted Hide Post
For those of you that are seeing performance issues, can you give me an idea of how big of results you're talking?

I think most of us at my org run 1gb of memory or less -- but I've got result sets that are around 20-25 columns wide and approx 250 rows depending on how the users run the report. I definitely see degradation when I get a lot more rows than that, but it does still flow pretty nicely.

Just curious at what threshold you all are seeing the degradation occur.



Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
 
Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005Report This Post
Expert
posted Hide Post
i saw that...i'm clueless but interested,as well.
Trav, my lockup happens when i have more than 1 BY field, and i want to lock, say, column 2 or higher. First time out, i locked at column 6, with fixed headers. Very amusing results...
A cool, but so-far-unneeded feature, you can lock JUST column 6, and everything else slides underneath it... Silly, but might come in handy someday




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Platinum Member
posted Hide Post
I should have said too that I am locking ALL headers in my report and column 1 only. I am also locking all report headings and I have 2 BYs I think.

As far as locking a column in the middle of the report -- it does sound fun. Maybe if you wanted to create some sort of "dual pane" effect or something? Can't think of a good application/example at the moment...



Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
 
Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005Report This Post
Member
posted Hide Post
I'm trying to freeze the report headers using the css file.
However, I still have a problem because I'm using an 'across report'

when I scroll, the data reappears in the upper left corner...

Across_1 Across_2 Across_3
Title_1 Title_2 Title_3 Title_4 Title_5 Title_6
A A A A A A
B B B B B B

After scroll

A A A Across_1 Across_2 Across_3
Title_1 Title_2 Title_3 Title_4 Title_5 Title_6
B B B B B B


7.6.4
Windows
Excell,HTML,PDF,Dashboard,…
 
Posts: 3 | Registered: December 05, 2008Report This Post
Expert
posted Hide Post
If you can easily upgrade, starting in 765 HFREEZE is available which allows you to fix headings and scroll the report. For HTML reports only.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Virtuoso
posted Hide Post
Ginny

This is perfect and so simple!!!

Where do you find the time to read all the Focus Manuals.....




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Expert
posted Hide Post
Well, Frank, I'm the WF admin and every time there is a new release, I take the time to read the SoNF to see if we want to move forward to that release. I'm like a kid in a candy store when it comes to that stuff.

I also support quite a number of business developers who ask me many questions that force me to do research.

Also I've been in the business 40 years and I've just always read manuals. I find it saves you time in the long run.

And I love HFREEZE! Winky


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Platinum Member
posted Hide Post
I just took a look at HFREEZE and I like it. Makes it very easy to implement header/footer/title freezing.

For what it's worth though, the method I use has the ability to freeze entire columns as well -- sort of like what you can do in Excel with freeze panes. Not trying to bash HFREEZE because it's definitely MUCH easier to implement than my CSS stuff!! But if you need to freeze more than just headers, footers, and column titles, you might not be able to use HFREEZE... I like the ability of HFREEZE to set a specific size to scroll, but in some cases you may not know that or may not want a fixed size.

Overall though, it's a great start and I hope they expand it's functionality because it would really make some of my stuff much easier to deal with...



Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
 
Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005Report This Post
Virtuoso
posted Hide Post
A column freeze (VFREEZE) would be nice, set 1 or more or all the by field columns frozen.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Expert
posted Hide Post
Frank,
Active Reports has a "VFREEZE" type thing..
but its a bit buggy.
it works fine on the car file, but get very fancy in your code, and it starts whacking out...especially if there are subtotal lines..




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Platinum Member
posted Hide Post
Any obvious way to set the scroll size in HFREEZE? That feature would be VERY useful if so...



Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
 
Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005Report This Post
Expert
posted Hide Post
Trav, yes, the hfreeze sets the size of the scroll window. 4 or 5 is the default, but you can set it to whatever you want. SCROLLHEIGHT i believe is the argument name.
Syntax: How to Scroll Report Output
Using StyleSheet attributes, you can set aside a scrollable area for HTML report output:

TYPE=REPORT, HFREEZE={ON|TOP|BOTTOM|OFF}, [ SCROLLHEIGHT={4|nn[.n]}], $
where:

HFREEZE=ON
Freezes the heading, column titles, grand totals, and footing.

HFREEZE=TOP
Freezes the heading and column titles.

HFREEZE=BOTTOM
Freezes the grand totals and footing.

nn[.n]
Is the height, in inches, of the scrollable area. The default is 4 inches.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Guru
posted Hide Post
HFREEZE doesn't work with multiple lines of Grand total. Any one has ideal why?
Thanks.

TABLE FILE CAR
SUM 
	SALES OVER
	DCOST OVER
	COMPUTE NET/D12 = SALES - DCOST;
BY CAR AS ''
ACROSS SEATS AS ''
ON TABLE COLUMN-TOTAL AS 'GRAND TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=ON,
     FONT='ARIAL',
	 HFREEZE=ON,
     SIZE=8,
$
ENDSTYLE
END  

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


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report This Post
Virtuoso
posted Hide Post
It's not the multiple grand total lines that cause hfreeze not to work,it's the OVER that prevents the HFREEZE feature from being activated. If you have OVER in place, your column headings are not on top any more, but are located to the left of the column value.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Guru
posted Hide Post
Thanks Gamp.

OVER was the requirement and the totals were aligned properly until I added the HFREEZE.
You could be right about the confusion of freezing titles when it goes side by side.

Hua

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


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report This Post
Guru
posted Hide Post
HFREEZE = TOP works just fine in my case. Thanks.

Hua


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report This Post
  Powered by Social Strata Page 1 2  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Freeze column headings (and row titles) in HTML output????

Copyright © 1996-2020 Information Builders