HTMLFORMTYPE AND 'TITLETEXT'

HI linus,

May be if I understood your question correctly here is the solution I have, Even I got same problem in order to rename the sheettab of the excel output when we go with SET HTMLFORMTYPE = XLS. I searched in forums but I did not get any solution

So, only if you use the EXL2K format obviously you will get the title text of the tab. Here is a high level idea which I suppose to say TO u

  

TABLE FILE EMPLOYEE 
PRINT FIRST_NAME LAST_NAME
ON TABLE HOLD AS RPT FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT,TITLETEXT='XYZ',$
END

SET HTMLFORMTYPE = XLS

-HTMLFORM BEGIN

<HTML>

<BODY>
!IBI.FIL.RPT;
</BODY>

</HTML>

-HTMLFORM END

Thanks!

WebFOCUS 7.6.10
Windows
Output: Excel,PDF

Posts: 78 | Registered: January 07, 2008

Ignored post by subbu posted

Platinum Member

posted

Thanks, I'll give this a shot.

WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF

Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007

Ignored post by linus posted

Platinum Member

posted

This doesn't solve my problem. I need the column titles to be rotated which requires html format, but the titletext on the tab is only for excel format. Thanks for the suggestion though.

WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF

Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007

Ignored post by linus posted

Dan Satchell

Virtuoso

posted

linus,

Regarding rotating the column headings vertical in Excel output, there is a posting on this site from December 8, 2005 entitled "Set Vertical Position for Column Titiles in PDF and EXCEL". Once of the responses to that posting from Francis Mariani describes a technique for doing so using embedded CSS with HTMLFORMTYPE=XLS. You may find your solution there.

This message has been edited. Last edited by: Dan Satchell,

WebFOCUS 7.7.05

Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007

Ignored post by Dan Satchell posted

Platinum Member

posted

I can get my column titles rotated, but I can't combine rotating my column title and displaying titletext on the worksheet tabs. I asked NY and they confirmed my assumption that combining these two is not possible.

WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF

Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007

Ignored post by linus posted

Francis Mariani

Expert

posted

linus, I've tinkered with this and have found no solution. One possible method is to use Excel Templates. Since you have multiple tabs, you would need one set of tabs where the styling is done and where references are made to another set of tabs filled by WebFOCUS. People seem to use VB with Excel, so you could perhaps hide the "data" tabs using VB.

Francis

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

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Platinum Member

posted

Thanks for the response Francis. I can't use templates because my requirement is for the process to run batch and be distributed via email (javamail); templates must be run via a web interface. Templates would resolve my issue of combining the two (rotated columns and titletext on the tabs). I've done this before, but your output has to be "on table pchold". Thanks again for taking the time to help.

WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF

Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007

Ignored post by linus posted