January 26, 2012, 08:10 AM
ArpitaUrgent: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
January 26, 2012, 09:41 AM
Tom FlynnArpita, 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