Focal Point
[CLOSED] Freeze column heading and column.

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

May 26, 2011, 09:35 AM
Neenz
[CLOSED] Freeze column heading and column.
I have a report and I need to freeze the column heading and the first 3 columns. I know that HFREEZE can be used for headings. Is there a similar way to freeze the columns too?

Eg:
col1 col2 col3 col4 col5 col6 col7
A1 B1 1 2 3 4 5
A2 B2 6 7 8 9 10
A3 B3 11 12 13 14 15
A4 B4 16 17 18 19 20
A5 B5 21 22 23 24 25

I need to freeze the column headings (col1, col2, col3, col4, col5, col6, col7) and the data in col1 and col2 .

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


WF: 7.6.8
OS/Platform: Windows, Unix
May 26, 2011, 01:50 PM
FrankDutch
It is not a basic function like the HFREEZE option.
But i would suggest you do a search in this forum.
The solution is here, just search and you will find it.


SEARCH is the most underestimation and helpfull thing in this forum.




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

May 31, 2011, 05:43 AM
JohnO
The only way I've seen this done is by using a hack to read the WF report HTML or XML into a JavaScript object and manipulate the structure. For example ExtJS provides a table to grid object which can be customized for WF HTML report output. The ExtJS grid object has scroll controls.


WF 7.6.8, Windows
Any output format: HTML, Excel, PDF, XML, etc.
May 31, 2011, 06:42 AM
Cyril Joy
If you are using Excel, you can go for Excel Templates.


Regards,
Cyril Joy.

WF Production 8008 on Linux.