January 28, 2008, 05:58 PM
<dksib>Excel pageing across with freeze
I am required to create a report that has 31 columns in Excel. It needs to freeze the Column Headinga when you scroll down and be able to go left or right 10 columns with the first 2 columns frozen, using arrow buttons on the bottome of the report display area. Can this be done in WebFocus MRE? At present, I am not allowed to create an excel template for this report. I have been playing with creating reports in HTMLTABLE and using htmlformtype=XLS.
All the help you can give me is greatly appreciated.
David
January 28, 2008, 08:49 PM
susannahdavid, that's a oneclick for the excel enduser, exceeds the capability of FORMAT EXL2K.
If you create a webquery, from Excel, perform the freezepane, and distribute the refreshable webquery, the freezepane will survive the refresh. I quite like that method; and also, as you write selfserves, the end user can create their own refreshable webquery from a report on your site with a simple right click export to excel, freeze their own panes, and refresh their own sheets.
January 29, 2008, 02:37 AM
Tony AExcept that the FORMAT EXL2K normally passes the XML output to a browser based Excel plug-in which does not have the capability of "freeze panes".
David,
If you can't get "those that need to be convinced" to see the logic of allowing you to create an Excel Template for this function then you would be better off running the query as a webquery within Excel (as Susannah states). However, if you are not permitted to create a template then are you allowed to create an Excel workbook with Macros and webqueries?
T
January 29, 2008, 09:08 AM
jgelonaAnother option is to use a template that has an embedded auto_open macro to do formating that WebFOCUS cannot do, i.e. Freeze Pane. I also do this to set page-setup, print margin, headings to repeat at the top, etc.
January 29, 2008, 10:05 AM
Tony Ajgelona,
That is the advantage of using Excel templates, but if David isn't permitted to use them and he can't get "those that need to open their minds" to see sense then he's well and truly stuck!!
T
January 30, 2008, 09:40 AM
jgelonaTony, I missed the part about not being able to use templates, bummer, and I thought we were behind.