Focal Point
[SOLVED] Formatting HTML Report

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

May 03, 2012, 01:47 PM
joyesiji
[SOLVED] Formatting HTML Report
I have this report
 
-* File a1.fex


-*TABLE FILE CAR
-*PRINT *
-*END



TABLE FILE CAR
PRINT  CAR AS '' MODEL AS '' BODYTYPE AS '' SEAT AS ''
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
"COUNTRY: <COUNTRY"
""
"CAR    <+0>        MODEL <+0>   BODY <+0>       SEAT "
"S <+0> TYPE<+0> "
HEADING
" "
"TESTING REPORT"
""
"Period:<+0>2011<+0>Year: <+0>2012"
""

ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
 UNITS=IN,
 SQUEEZE=ON,
 ORIENTATION=PORTRAIT,

$
TYPE=REPORT,
 GRID=OFF,
 FONT='TIMES NEW ROMAN',
 SIZE=10,
$
TYPE=TITLE,
 SIZE=10,
 FONT=TIMES NEW ROMAN,
$
-* Used for setting the Period
TYPE=HEADING,
STYLE=BOLD,
JUSTIFY=CENTER,
LINE=2,
$
TYPE=HEADING,
STYLE=BOLD,
JUSTIFY=LEFT,
LINE=4,
ITEM=1,
OBJECT=TEXT,
POSITION=2.00,
$
TYPE=HEADING,
STYLE=BOLD,
JUSTIFY=LEFT,
LINE=4,
ITEM=2,
OBJECT=TEXT,
POSITION=2.50,
$
TYPE=SUBHEAD,
 LINE=1,
 OBJECT=TEXT,
 STYLE=BOLD,
 SIZE=10,
 POSITION=1.6,
 $

TYPE=SUBHEAD,
 LINE=2,
 OBJECT=TEXT,
 STYLE=BOLD,
 SIZE=10,
 $

TYPE=SUBHEAD,
 LINE=3,
 OBJECT=TEXT,
 STYLE=BOLD,
 SIZE=10,
 $
-* APPORTIONMENT SUBHEAD
TYPE=SUBHEAD,
 LINE=3,
 OBJECT=TEXT,
 ITEM=1,
 STYLE=BOLD,
 SIZE=10,
 COLSPAN=3,
 POSITION=.50,
 $
TYPE=SUBHEAD,
 LINE=3,
 OBJECT=TEXT,
 ITEM=2,
 STYLE=BOLD,
 SIZE=10,
 COLSPAN=3,
  POSITION=.70,
 $
TYPE=SUBHEAD,
 LINE=3,
 OBJECT=TEXT,
 ITEM=3,
 STYLE=BOLD,
 SIZE=10,
 COLSPAN=3,
 POSITION=.90,
 $
 TYPE=SUBHEAD,
 LINE=3,
 OBJECT=TEXT,
 ITEM=4,
 STYLE=BOLD,
 SIZE=10,
 COLSPAN=3,
  POSITION=1.10,
 $
-*##########################################################Begin Second Line SubHead#################################################
TYPE=SUBHEAD,
 LINE=4,
 OBJECT=TEXT,
 ITEM=1,
 STYLE=BOLD,
 SIZE=10,
 COLSPAN=3,
  POSITION=.56,

 $

TYPE=SUBHEAD,
 LINE=4,
 OBJECT=TEXT,
 ITEM=2,
 STYLE=BOLD,
 SIZE=10,
 COLSPAN=3,
 POSITION=3.22,
 $
-*##########################################################End Second Line SubHead#################################################
-*##########################################################Begin Data Styling#################################################
 TYPE=DATA,
 COLUMN=C1,
 SIZE=10,
 COLSPAN=3,
 SQUEEZE=2.0,
 JUSTIFY=CENTER,

 $
 TYPE=DATA,
 COLUMN=C2,
 SIZE=10,
 COLSPAN=3,
 SQUEEZE=2.2,
 $
 TYPE=DATA,
 COLUMN=C3,
 SIZE=10,
 COLSPAN=3,
 SQUEEZE=1.8,
 $
-*##########################################################End Data Styling#################################################


TYPE=DATA,
 COLUMN=N3,
WIDTH=0.12,
$


ENDSTYLE
END
 


I will like a horizontal Line to be above and below the rows. That is there should be a line above and below Jaguar and V12XKE AUTO. There should also be a seperate line above and below Convertible and 2. And this should be in every Data row. Please how do i accomplish this

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


WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
May 03, 2012, 02:45 PM
Rao D
Try using the BORDER option

TYPE=DATA,
COLUMN=C1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-COLOR=RED,
BORDER-STYLE=SOLID,
SIZE=10,
COLSPAN=3,
SQUEEZE=2.0,
JUSTIFY=CENTER,

$


WebFOCUS - ver8201
[ReportingServers: Windows 64bit;
Client: tomcat and IIS on windows 2012
AppStudio

May 03, 2012, 05:43 PM
Waz
If all else fails, you could embed the HR tag in the report, as it is an HTML report.


Waz...

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