Hi,

Can anyone help me out in marking borders around some of the fields in the Header section of my HTML & PDF reports in WebFocus?

I have tried using HGRID & VGRID attributes for marking borders in PDF report, which didn't work out.

Below is the mock-up of the report which shows the REPORT HEADING, HEADER portion & DETAIL portion.I wanted to put the below shown 2 fields(FE DATE & FE Score, which exists in the HEADER portion of the report) along with their values together in a single box(require borders in both HTML & PDF reports).

FE DATE: 10/10/2008
FE Score: YELLOW - 85.72


MOCK-UP OF THE REPORT

HEADING OF THE REPORT:

FACTORY SCORE CARD

HEADER PORTION OF THE REPORT:

Factory Status: YELLOW % Accept Sampled Units: 96.2%
Factory Name: PT. Dream Sentosa Indonesia % Passed Inspections: 98.97%
Factory ID: 1234 On-time Inspection: 99.27%
Factory Addr: Mangga Besar 2 Rt 16/04 Walahar, Klari,
Building 1,2, 1/F- 4, 2/F-5,Jawa Barat
(West Java),Karawang,Indonesia #Market Withdrawals: TBD
FE DATE: 10/10/2008
FE Score: YELLOW - 85.72
DETAIL PORTION OF THE REPORT:


Vendor# Inspections# Passed# Sampled Units# Acceptable Sampled Units% Passed Inspections% Acceptable Sampled UnitsVendor Factory Status

SHIN SUNG TONG SAN/AMC/FLC 1 1 125 120 100.00% 96.0%
SHIN SUNG TONGSAN/AMC/FLC 16 16 1775 1669 100.00% 94.0%
SHINSUNG TONGSANG 1 1 80 74 100.00% 92.5% GREEN - 84.88%
Total # Sampled Units:1980

Kindly give me some tips on what attributes can be used for marking borders if anybody knows..

Thanks & Regards
Tejovathi.S

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

Unfortunately, you cannot add borders to specific pieces of a HEADING, you can't even do it for one line in the HEADING, it's either the whole HEADING or nothing.

You can, however, change the style or color or background color:

TABLE FILE CAR
SUM
SALES
SEATS NOPRINT
BY COUNTRY
BY CAR
BY MODEL

HEADING
"WEBFOCUS REPORT"
"FE DATE: <CAR"
"FE SCORE <SEATS"
WHERE READLIMIT EQ 100
WHERE RECORDLIMIT EQ 100
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLESHEET *
FONT='ARIAL', SIZE=8, GRID=OFF, $
TYPE=HEADING, HEADALIGN=BODY, $
TYPE=HEADING, LINE=2, BACKCOLOR=RED, $
TYPE=HEADING, LINE=3, BACKCOLOR=RED, $
ENDSTYLE
END

to expand on the post from Francis

 TABLE FILE CAR
"MY HEADING"
"COUNTRY <COUNTRY <+0>"
SUM DCOST RCOST
BY COUNTRY 
BY CAR
BY MODEL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *
TYPE=REPORT,GRID=OFF,$
TYPE=HEADING,LINE=2,ITEM=1,BACKCOLOR=SILVER,$
TYPE=HEADING,LINE=2,ITEM=2,BACKCOLOR=SILVER,$
ENDSTYLE
END

the <+0> is important for PDF otherwise the colour will be for the whole line
and not the 2 cells you are interested in. 

Expanding JG post the border can be done for html output but dont know the way to do it for pdf , try this it might be helpfull

DEFINE FILE CAR
TAB/A1000='<table border="1" width="50%" id="table1" style="border-collapse: collapse" bordercolor="#000000"><tr><td>COUNTRY '|COUNTRY|'</td></tr></table>';
END
TABLE FILE CAR
"MY HEADING"
"<TAB <+0>"
SUM DCOST RCOST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *
TYPE=REPORT,GRID=OFF,$
TYPE=HEADING,LINE=2,ITEM=1,BACKCOLOR=SILVER,$
TYPE=HEADING,LINE=2,ITEM=2,BACKCOLOR=SILVER,$
ENDSTYLE
END

Will this work if the width of the cell changes depending on the data contained within it?

You should be able to add borders in HTML with CSS.

With PDF, you could try using the the stylesheet option OBJECT=BOX. It is limited and fixed, have a search in the forum.

It depends on the version you are using but in 7.6.6 you can put a grid in your heading and change the bg color of each cell. Change the character color and size. I'm not sure about the borders.