Is there option that I can set data justify = TOP-LEFT?This message has been edited. Last edited by: hainguyen,
WebFOCUS 7.7.03 Windows, All Outputs
August 26, 2014, 12:20 PM
diogopc
As far as I know, it's not possible.
WebFOCUS App Studio 8103 Windows7 All outputs
August 26, 2014, 01:59 PM
Francis Mariani
I don't understand the question so I cannot give you a firm answer. What do you mean by "data"? What do you mean by "TOP"?
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
August 26, 2014, 03:06 PM
susannah
-SET &ECHO = ALL ;
TABLE FILE IBISAMP/CAR
BY COUNTRY BY CAR SUM SALES DCOST
ON TABLE HOLD AS MYTAB FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=DCOST,CLASS=c1 , $
END
-RUN
-HTMLFORM BEGIN
<HTML>
<head>
<style>
.c1 {vertical-align:top; text-align:left;font-family:ARIAL; font-size:9pt; font-variant:small-caps; color:#000000;
border-top: 1.00pt SOLID #C0C0C0; border-bottom: NONE; border-right: NONE; border-left: NONE; }
</style>
</head>
<body>
!IBI.FIL.MYTAB;
</body>
</HTML>
-HTMLFORM END
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
August 26, 2014, 03:10 PM
Francis Mariani
Voila.
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
August 26, 2014, 03:50 PM
hainguyen
Thanks susannah. But I don't have any issue with HTML output. HTML output still keeps TOP-LEFT align even I don't use style sheet but Excel output is changed to BOTTOM-LEFT align somehow. I can't find the way to fix this in WebFocus.
WebFOCUS 7.7.03 Windows, All Outputs
August 26, 2014, 05:23 PM
Francis Mariani
We all wish you had mentioned "Excel" in your first post. Please post an example fex that illustrates the problem you're having.
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
August 26, 2014, 05:37 PM
hainguyen
My bad, this is my example code:
TABLE FILE SQLOUT
PRINT
ACTION
INCIDENT
WORKERTYPEDESC
BY DIVISIONNAME
BY ID
BY DESCRIPTION
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT,
COLUMN=N3,
WRAP=4.000000,
$
ENDSTYLE
END
It appears that the first record displayed contains blank DIVISIONNAME and ID values.
8009 Windows, HTML, AHTML, Excel In FOCUS since 1983
August 27, 2014, 10:03 AM
Francis Mariani
Here is one method to have data in Excel vertically aligned to the top of the cell. it uses the HTMLFORMTYPE=XLS setting along with some CSS.
Unfortunately, though it does indeed vertically align the text to the top of the cell, there are other issues I haven't overcome, e.g. borders on the cells outside the report do not display.
I've commented the lines of code that don't seem to make any difference. Perhaps someone else can add to this.
SET PAGE=NOLEAD
-RUN
TABLE FILE CAR
SUM
SALES
DEALER_COST
RETAIL_COST
BY COUNTRY
BY CAR
BY WARRANTY
ON TABLE SET HTMLCSS ON
ON TABLE HOLD AS REP001 FORMAT HTMTABLE
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT,
BORDER=0.1,
BORDER-COLOR=RGB(208 215 229),
$
TYPE=REPORT,
COLUMN=N3,
WRAP=1.000000,
$
TYPE=DATA,
CLASS=vertical-top,
$
ENDSTYLE
END
-RUN
SET HTMLFORMTYPE=XLS
-RUN
-HTMLFORM BEGIN
<style>
.vertical-top {
vertical-align: top;
border-style: 5px solid red;
}
/*
body {
background-color: transparent;
}
td {
border-style: 5px solid green;
}
*/
</style>
<body>
!IBI.FIL.REP001;
</body>
-HTMLFORM END
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
August 27, 2014, 04:26 PM
hainguyen
Thanks Francis. It is worth to try.
WebFOCUS 7.7.03 Windows, All Outputs
April 07, 2015, 05:12 PM
nsk110483
Hi Francis,
I can use your solution for the similar problem I have. However I have a multiple sheet excel compound report. How do I use HTMLFORTYPE and achieve that?
Thanks for any help
In Focus since 2008 WebFOCUS 8.2.0.1 Windows 7 - IE,Chrome,Firefox Excel, PDF, HTML, AHTML, XML JavaScript, jQuery, D3.js, Highcharts
April 08, 2015, 09:21 AM
jgelona
Actually, I have an open NFR to provide this and it has been sent to programming. I have asked that JUSTIFY have 2 components, horizontal and vertical separated by a "-". The horizontal would have the existing options of LEFT, CENTER and RIGHT. The vertical component would have TOP, CENTER and BOTTOM. So JUSTIFY would could be LEFT-TOP or CENTER-CENTER, etc.
The supplied solution uses a simple style sheet, I normally do this with a macro enabled template.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
May 10, 2016, 07:44 PM
vaayu
Hello Francis and Susannah, I enjoy reading both your posts and I'm looking to find a way to justify DATA on the SORT FIELD (eg; COUNTRY) vertical center in HTML. Since ENGLAND appears for first 3 rows in this example, my client wants to see it as one cell centered/middle. I"m not sure how we can merge the row and justify at the same time.