[CLOSED] Rotate Column Headings 90 Degrees.

How would I rotate the column headings ('Country', 'Car',...) 90 degrees, in the report below?

I have many columns, in my report, so I am required to save as much space as possible.

-******************************************************************************
-** Create Report.
-******************************************************************************
TABLE FILE CAR
"Heading Line 111111111111111111111111"
"Heading Line 222222222222222222222222"
PRINT RCOST   AS 'Retail,Cost'
      DCOST   AS 'Dealer,Cost'
BY    COUNTRY AS 'Country'
BY    CAR     AS 'Car'
ON TABLE HOLD AS HLDALLO FORMAT HTMTABLE
ON TABLE SET DROPBLNKLINE ALL
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
-* Report styling.
ON TABLE SET STYLE *
TYPE=HEADING,
     BORDER=LIGHT,BORDER-COLOR=RGB(200 200 220),BORDER-STYLE=OUTSET,
     BACKCOLOR=RGB(1 53 112),STYLE=BOLD,SIZE=10,$
TYPE=HEADING,STYLE=BOLD,SIZE=10,JUSTIFY=LEFT,
     BACKCOLOR=RGB(1 53 112),COLOR=RGB(227 232 238),$
TYPE=REPORT,HFREEZE=TOP,SCROLLHEIGHT=1.3, $
TYPE=TITLE,SIZE=9,STYLE=-UNDERLINE+BOLD,BACKCOLOR=RGB(220 218 195),COLOR=RGB(134 10 39),
     BORDER-STYLE=OUTSET,BORDER=LIGHT,BORDER-COLOR=RGB(255 255 255),$
ENDSTYLE
END
-RUN
-******************************************************************************
-** Report presentation to user.
-******************************************************************************
-HTMLFORM BEGIN
<!DOCTYPE html>
<html>
<head>
-*
</head>
<style>
-* Note: The blank line, between the heading and column titles has a class of 'x3'.
	  .x3 {
	   display:none;
	  }
</style>
!IBI.OBJ.HFREEZEJS;
<BODY ONLOAD='!IBI.OBJ.IBIGBLONLOAD;'>
  !IBI.FIL.HLDALLO;
  !IBI.OBJ.IBIGBLJS;
</body>
</html>
-HTMLFORM END
-EXIT

FocalPoint search results seem to suggest this type of thing is possible for 'Across Column Titles'. In my case I'd like to rotate 'Report Column Titles'.

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

Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster

Posts: 822 | Registered: April 23, 2003

Waz

Expert

posted

Hide Post

If its HTML, then I would suggest using CSS to do it.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Ignored post by Waz posted

Show Post

David Briars

Master

posted

Hide Post

I created a .css file that look like this:

.reportTitles {
                 color: red;
                 transform: rotate(-90deg);
                }

I then assign the class '.reportTitles' to the TITLE section of the report, and drop in the .css file:

-* File rotatecolheading.fex
-******************************************************************************
-** Create Report.
-******************************************************************************
TABLE FILE CAR
"Heading Line 111111111111111111111111"
"Heading Line 222222222222222222222222"
PRINT RCOST   AS 'Retail,Cost'
      DCOST   AS 'Dealer,Cost'
BY    COUNTRY AS 'Country'
BY    CAR     AS 'Car'
ON TABLE HOLD AS HLDALLO FORMAT HTMTABLE
ON TABLE SET DROPBLNKLINE ALL
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
-* Report styling.
ON TABLE SET STYLE *
TYPE=REPORT, CSSURL=http://localhost:8080/approot/work/rotate.css, $
TYPE=HEADING,
     BORDER=LIGHT,BORDER-COLOR=RGB(200 200 220),BORDER-STYLE=OUTSET,
     BACKCOLOR=RGB(1 53 112),STYLE=BOLD,SIZE=10,$
TYPE=HEADING,STYLE=BOLD,SIZE=10,JUSTIFY=LEFT,
     BACKCOLOR=RGB(1 53 112),COLOR=RGB(227 232 238),$
TYPE=REPORT,HFREEZE=TOP,SCROLLHEIGHT=1.3, $
-*TYPE=TITLE,SIZE=9,STYLE=-UNDERLINE+BOLD,BACKCOLOR=RGB(220 218 195),COLOR=RGB(134 10 39),
-*     BORDER-STYLE=OUTSET,BORDER=LIGHT,BORDER-COLOR=RGB(255 255 255),$
TYPE=TITLE, CLASS=reportTitles,$
ENDSTYLE
END
-RUN
-******************************************************************************
-** Report presentation to user.
-******************************************************************************
-HTMLFORM BEGIN
<!DOCTYPE html>
<html>
<head>
</head>
!IBI.OBJ.HFREEZEJS;
<BODY ONLOAD='!IBI.OBJ.IBIGBLONLOAD;'>
  !IBI.FIL.HLDALLO;
  !IBI.OBJ.IBIGBLJS;
</body>
</html>
-HTMLFORM END
-EXIT

If I am on the right track, can someone assist me with making sure the rotated column headings do not appear on top of the DATA section?

If someone has another approach, I'd be all ears, as well.

Posts: 822 | Registered: April 23, 2003

Ignored post by David Briars posted

Show Post

Tony A

Expert

posted

Hide Post

Have a look at using "writing-mode" as per Susannah in this post?

I tried it instead of your "transform" attribute and it worked ok.

T