Does anyone know if you can Freeze Rows or Columns when using the Excel Output? Have some not so tech savvy users who could benefit from this.This message has been edited. Last edited by: Kerry,
Robert B. Clark -- Business Systems Analyst Daimler Trucks North America Phone: 503.745.7057 "There's always a better way." IBM Mainframe zOS 8.1.05, DB2 adapter WF 8.1.05 Hub to Sub, Self-Service, SQL Server adapter
September 25, 2009, 01:34 PM
Prarie
You should be able to do that with Excel Templates.
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
September 25, 2009, 01:47 PM
Robert B Clark
Prarie, Could you elaborate, just a bit. Do you have a page or chapter in the Creating Reports with WebFOCUS that I can review? Thank you. -robert-
Robert B. Clark -- Business Systems Analyst Daimler Trucks North America Phone: 503.745.7057 "There's always a better way." IBM Mainframe zOS 8.1.05, DB2 adapter WF 8.1.05 Hub to Sub, Self-Service, SQL Server adapter
September 28, 2009, 10:29 AM
Prarie
Robert,
I have not personally done this..so i don't have an example. If you do a search in Help or the IBI tech site you should be able to find some instruction. Good Luck.
September 28, 2009, 03:17 PM
Francis Mariani
Could you please elaborate what you mean by "Freeze Rows or Columns" when using Excel?
Do you mean "Freeze Panes"?
If so, you can create an Excel template that WebFOCUS uses to populate the data in one tab, and have a second tab that manipulates the first, with the Freeze Pane set.
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
September 29, 2009, 10:06 AM
knegrotto
I got help with this issue on the forum. And I documented it so I don't mind saving you the time it took me to research the issue.
1) Create an Excel template file.The worksheet must contain at least 2 sheets and each must contain data. You can input a blank in column a1 of each or some identifying text. It will be overwritten when the report is written.
2) Create a macro named auto_open that freezes the headings at the appropriate cell, as follows:
Sub auto_open() ' ' auto_open Macro ' Range("A2").Select ActiveWindow.FreezePanes = True End Sub
3) The range A2 above allows for a single row of columns headings but no freeze on the columns. To add rows to the freeze, adjust range accordingly (IE: A2, A3, etc) To freeze the first column and row, select range B2.
4) Save it as an .mht file on the web focus server. I called mine Excel_Template.mht and saved it in our application directory
5) Add the following parameters to your PCHOLD command
ON TABLE PCHOLD FORMAT &USER_OUTPUT TEMPLATE Excel_Template SHEETNUMBER 1
Only issue we found is that Excel to allow the macro code to run. When set to high, you will not receive any message; the macro will be ignored.This message has been edited. Last edited by: knegrotto,
WebFOCUS 769 Windows all
October 06, 2009, 11:08 AM
Robert B Clark
We have a Hub-Sub environment. I use WebFOCUS 7.6, not the mainframe FOCUS here at DTNA, and have my users run from an HTML page, so everything comes back to them via an IE window, whether PDF, Excel, HTML, etc. The dilemma: I need to have that Excel Template loaded to the EDAPATH or App Path for our environment. Where is that configuration information stored? In the WebFOCUS Administration Console? The Managed Reporting Administration web page? Somewhere on the mainframe? I did find in the WebFOCUS Admin Console under Configuration/Managed Reporting called MR_TEMPLATE_DIR. Is this it. I'll take any and all suggestions. I work very closely with our BI IT department and they'll implement or even let me setup and test the configuration, once I've located where it's at. So any help would be much appreciated if someone has experience in a similar Hub-Sub environment.
Robert B. Clark -- Business Systems Analyst Daimler Trucks North America Phone: 503.745.7057 "There's always a better way." IBM Mainframe zOS 8.1.05, DB2 adapter WF 8.1.05 Hub to Sub, Self-Service, SQL Server adapter
October 06, 2009, 11:42 AM
Kerry
Hi Robert,
Please check your private message, in which I explained the reason that a case will be better to handle this type of questions.
Cheers,
Kerry
Kerry Zhan Focal Point Moderator Information Builders, Inc.
October 06, 2009, 11:51 AM
<JG>
Robert you should not have an issue.
Hub-Sub means you get the data from the sub then you output it via the hub.
The template file should be stored in an apps folder on the WebFOCUS environment (hub) not the sub-server.