Focal Point
Urgent:Formatting issue with Across column border,HTML

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9217088516

January 26, 2012, 08:10 AM
Arpita
Urgent:Formatting issue with Across column border,HTML
Hi,
I am facing formatting issue with Across column border in Html format.
In my code i have done ACROSS by two fileds.The first field is dynamic depending upon the user selection.
When i am trying to add border around this field,right border is not coming up.Its coming as a blank.Rest of the side of the borders are diplaying fine.
I have tried lots of different syntax but nothing is working properly.
Please let em know , if you need any more information.
Any advice will be appreciated.

Mnay Thanks
Arpita


WebFOCUS 7.6
Windows, All Outputs
January 26, 2012, 08:19 AM
njsden
Arpita, that is sadly a "known" issue and still happens in WF 7.7.03.

Adding a COMPUTE dummy field right after your ACROSS and playing with the styling may help.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
January 26, 2012, 08:23 AM
njsden
Silly me! any COMPUTE field will be displayed in the data portion and won't make it up to the ACROSSVALUE line Frowner




Perhaps using an external CSS may help?



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
January 26, 2012, 08:27 AM
ReddyP
Can you post a simple car file example?
I had the same problem but I was able to get around with it by using borders on one side and specifying the borders for the across column name specifically for the value that has missing border.


7.7.01,windows2008 R2
January 26, 2012, 09:41 AM
Tom Flynn
Arpita, this is a known bug. We use CSS styling, example below, which is just a snippet of Production code.
This is the concept we use, notice the ACROSSVALUE line and CLASS=:

  
TABLE FILE CAR
SUM
     CAR
BY COUNTRY
ACROSS  SEAT AS ''
ACROSS MODEL AS ''
ON TABLE SUBHEAD
"Tata Steel Strip Products UK Weekly Details of Clocked Hours "
HEADING
"Date: <+0>&DATEtrMDYY "
FOOTING
"Page:<TABPAGENO of <TABLASTPAGE"
ON TABLE SUBFOOT
""
ON TABLE SET PAGE-NUM OFF
ON TABLE ROW-TOTAL AS 'Annual Total'
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE HOLD AS RPT1 FORMAT HTMTABLE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=OFF,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     FONT='ARIAL',	 
$
TYPE=DATA,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     SIZE=9,
     BACKCOLOR=( RGB(210 166 255) RGB(159 207 255) ),
     STYLE=NORMAL,
     JUSTIFY=CENTER,
$

TYPE=ACROSSVALUE, CLASS=border_sf1,
-*     BORDER-TOP=MEDIUM,
-*     BORDER-BOTTOM=MEDIUM,
-*     BORDER-LEFT=MEDIUM,
-*     BORDER-RIGHT=MEDIUM,
-*     SIZE=10,
-*     BACKCOLOR='SILVER',
-*     STYLE=BOLD,
-*     JUSTIFY=CENTER,
$

TYPE=TITLE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     SIZE=10,
     BACKCOLOR='SILVER',
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=TABHEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=20,
     COLOR=RGB(51 102 255),
     STYLE=BOLD,
$
TYPE=HEADING,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='SILVER',
$
TYPE=HEADING,
     LINE=1,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     STYLE=BOLD,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     STYLE=BOLD,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     STYLE=BOLD,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=4,
     STYLE=BOLD,
     JUSTIFY=LEFT,
     WIDTH=1.750,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=5,
     JUSTIFY=LEFT,
     WIDTH=1.875,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=6,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=7,
     SIZE=9,
     STYLE=BOLD,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=FOOTING,
     STYLE=BOLD,
     JUSTIFY=LEFT,
$
TYPE=FOOTING,
     LINE=1,
     JUSTIFY=RIGHT,
$
TYPE=FOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     JUSTIFY=CENTER,
     WIDTH=.625,
$
TYPE=FOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     STYLE=NORMAL,
     JUSTIFY=LEFT,
     WIDTH=.375,
$
TYPE=FOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     JUSTIFY=CENTER,
     WIDTH=1.000,
$
TYPE=FOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=4,
     STYLE=NORMAL,
     JUSTIFY=CENTER,
     WIDTH=.500,
$
TYPE=FOOTING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     STYLE=NORMAL,
     JUSTIFY=CENTER,
     WIDTH=.625,
$
TYPE=FOOTING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=2,
     STYLE=NORMAL,
     JUSTIFY=CENTER,
     WIDTH=.500,
$
TYPE=SUBHEAD,
     BY=1,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR=RGB(153 153 153),
     JUSTIFY=LEFT,
$
TYPE=SUBHEAD,
     BY=1,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     STYLE=BOLD,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=1,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=1,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     STYLE=BOLD,
     WIDTH=2.500,
$
TYPE=SUBHEAD,
     BY=2,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='SILVER',
     JUSTIFY=LEFT,
$
TYPE=SUBHEAD,
     BY=2,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     STYLE=BOLD,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=2,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     WIDTH=1.000,
$
TYPE=SUBHEAD,
     BY=2,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     STYLE=BOLD,
     WIDTH=2.500,
$
TYPE=GRANDTOTAL,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BACKCOLOR='SILVER',
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=REPORT,SQUEEZE= 0.527778,$
TYPE=REPORT,COLUMN=N1,SQUEEZE=2.430556,$
TYPE=REPORT,
     COLUMN=N3,
     SQUEEZE=0.930556,
$
TYPE=DATA,
     COLUMN=ROWTOTAL(1),
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     SIZE=9,
     BACKCOLOR='SILVER',
     STYLE=NORMAL,
     JUSTIFY=CENTER,
$
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"  "http://www.w3.org/TR/html4/loose.dtd">
<html>
<meta http-equiv="Pragma" content="no-cache">
<style type="text/css">
.border_sf1
{
border-top:solid black;
border-left:solid black;
border-right:solid black;
border-bottom: thin solid black;
border-width:2px;
font-size : 9pt;
font-weight: bold;
text-align: center;
background-color: RGB(204 255 204);
z-index: 20;
}
</style>
<BODY>
<div CLASS="contstyle">
!IBI.FIL.RPT1;
</div>
</BODY>
</html>
-HTMLFORM END
-EXIT



Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe