HTMLFORMTYPE AND 'TITLETEXT'

November 17, 2009, 11:19 AM

I have to create a workbook with five tabs, one for each region, which is not hard to do, but at the same time I have to turn my column headings vertical. I'm using the htmlformtype logic, but the 'titletext=value' in the stylesheet is not recognized in html. I've searched the forum and did not find anything on using these two items in conjunction with one another. Has anybody else had to do this, and if so how did you resolve it?

Thanks.

November 19, 2009, 09:56 AM

subbu

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!

November 20, 2009, 11:10 AM

linus

Thanks, I'll give this a shot.

November 20, 2009, 04:30 PM

linus

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.

November 21, 2009, 08:41 AM

Dan Satchell

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,

November 23, 2009, 08:51 AM

linus

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.

November 23, 2009, 10:10 AM

Francis Mariani

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

November 24, 2009, 09:02 AM

linus

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.