I am looking to make my column titles display vertically (or slanted) in an Excel 2000 output. The reason being because I am reporting an all columns in a table and several of them are only 1-character data fields. Having the column titles horizontally is wasting too much space.

Thanks

I know it can be done in HTML (search for it) and in PDF too, but Excel???
You can however create a macro in Excel to do this after the creation of the excel sheet

I believe there is a way to do this with CSS, HTMLFORMTYPE and HTMLFORM.

Kevin, I've just had a play at lunch, and here is what I came up with.

SET CSSURL='dummy.css'

DEFINE FILE CAR
 Style/A200 = '<' | 'style>.xl101 {mso-style-parent:style0;mso-rotate:45;height:70px;}'
            | ' .xl102 {mso-style-parent:style0;mso-rotate:-45;height:70px;}<' | '/style>' ;
END
TABLE   FILE CAR
 HEADING
 "<Style"
 PRINT  COUNTRY AS 'Country'
        CAR     AS 'Car'
        MODEL   AS 'Model'
 ON     TABLE PCHOLD FORMAT EXL2K
 ON     TABLE SET STYLE *
        TYPE=TITLE, COLUMN=COUNTRY, STYLE=BOLD, CLASS=rot_title, $
        TYPE=TITLE, COLUMN=CAR,     STYLE=BOLD, CLASS=rot_title, $
        ENDSTYLE
END

It relies on the you knowing the classes produced, but seems to work.

Here is the link to an old CTSS Newsletter article 'Using HTMLFORMTYPE to trigger Excel Features from WebFOCUS Code'.

[Link Removed]

This message has been edited. Last edited by: Kathleen Butler,

so old its not there anymore
404 error
this is the link you're pointing us to.
check to make sure its wht one you want.

quote:

had a play at lunch

no ordinary mortal's lunch! so cool.

This message has been edited. Last edited by: Kathleen Butler,

Here is the sample code:

SET CSSURL=http://localhost/approot/baseapp/h1.css
SET PAGE=NOLEAD
SET GRID=OFF
DEFINE FILE EMPLOYEE
NAME/A26=FIRST_NAME|' '|LAST_NAME;
END
TABLE FILE EMPLOYEE
SUM ED_HRS/I7 AS ''
BY DAT_INC AS ''
ACROSS NAME AS ''
ON TABLE SET HTMLCSS ON
ON TABLE HOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE=ACROSSVALUE,CLASS=rotate,$
TYPE=DATA,CLASS=border,$
ENDSTYLE
END
-RUN
SET HTMLFORMTYPE=XLS
-HTMLFORM HOLD

The report references a Cascading Style Sheet (CSS) file in the BASEAPP application:

.border
{
font-size:9pt;
text-align:right;
border-style:solid solid double;
}
.rotate
{
mso-rotate:90;
vertical-align:bottom;
height:175;
}

Sweet...imagine what would happen if, when WAZ went out to lunch, he took AG with him........

This message has been edited. Last edited by: susannah,

I got the code to work for Excel. My required outout is PDF. How do we produce the same report with the rotated column titles in PDF output format.

Thanks.

PDF is a COMPLETELY different animal. You may want to check out the post located here created by Warren (Waz). Seems to have been helpful for many users trying to to the same thing as you.