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,

You should be able to do that with Excel Templates.

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,

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.

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.

Look for Creating Reports With WebFOCUS Language > Choosing a Display Format > Using Excel Display Formats: Excel 2000, Excel 97, Excel > Creating Excel Templates

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,

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.

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

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.