Is there any way to remove the blank line between the report content and the Page Footing and replace it with an actual line..

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

Take a look at
SET DROPBLNKLINE
This may be helpful.

Can be achieved thorugh FOOTING BORDER and coressponding STYLING.

Thanks Jimster06 and Ramkumar for your replies..
According to the documentation this should remove the Blank line unless explicitly inserted by the user...
SET DROPBLNKLINE=ON

But it didnt work for me tried everything... I could get rid of the line only when i Used GRID=ON or used SUBFOOT instead of footing... So That should solve my first problem... But I am trying to get to the bottom of why it didnt work for me....

I tried using BORDER-TOP in the styling but nothing showed up.. I will try recreating the whole thing using car file and let you knowif it worked...

Thanks,
pvparuc

SET DROPBLNKLINE=ON

will not remove the blank line between the HEADING or FOOTING and the body of the report.

Please specify the format of the report - HTML or PDF? If it's HTML, are you using HTMLCSS=ON? These variations may make a difference.
Use this example:

TABLE FILE CAR
PRINT
*
HEADING
"WEBFOCUS REPORT HEADING"
FOOTING
"WEBFOCUS REPORT FOOTING"

ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, FONT='ARIAL', SIZE=8, $
TYPE=REPORT, BORDER=1, BORDER-COLOR=SILVER, $
ENDSTYLE
END

Comment/uncomment these two lines to see annoying changes to the report:

- HTMLCSS
- BORDER

Here is an example of what i am trying to achieve using the car file.. I am trying to replace the extra line between the footing and body with an actual line...

WEBFOCUS REPORT HEADING

COUNTRY DEALER_COST RETAIL_COST SALES
ENGLAND 37,853 45,319 12000
FRANCE 4,631 5,610 0
ITALY 41,235 51,065 30200
JAPAN 5,512 6,478 78030
W GERMANY 54,563 64,732 88190

TOTAL 143,794 64,732 88190

here Is what I did using the SUBFOOT instead of footing..

TABLE FILE CAR
SUM DEALER_COST
RETAIL_COST
SALES
COMPUTE DUMMY/A2 = 'A'; NOPRINT
BY DUMMY NOPRINT
BY COUNTRY
HEADING
"WEBFOCUS REPORT HEADING"
ON DUMMY SUBFOOT
"TOTAL<+0>TOT.DEALER_COST<+0>RETAIL_COST<+0>SALES"

ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
TYPE=REPORT, FONT='ARIAL', SIZE=8, GRID=OFF, STYLE=NORMAL,$
TYPE=SUBFOOT, HEADALIGN=BODY, FONT=ARIAL, SIZE=8, STYLE=BOLD, $
TYPE=SUBFOOT, LINE=1, ITEM=1, JUSTIFY=LEFT, POSITION=COUNTRY, $
TYPE=SUBFOOT, LINE=1, ITEM=2, JUSTIFY=RIGHT, POSITION=DEALER_COST, $
TYPE=SUBFOOT, LINE=1, ITEM=3, JUSTIFY=RIGHT, POSITION=RETAIL_COST, $
TYPE=SUBFOOT, LINE=1, ITEM=4, JUSTIFY=RIGHT, POSITION=SALES, $
ENDSTYLE
END

but I am not able to get the line in between them tried using UNDER-LINE but it is getting the line after the SUBFOOT...

I trying to get the Output in HTML.. As I have to use an existing style sheet and I dont get the desired Output if the HTMLCSS is ON.. but i wont be getting the line using BORDER-TOP without that setting...

Any ideas on how to get a line in between... or any other way of removing the line without creating a Dummy Field..

Thanks in Advance,
pvparuc

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

Is there any way I can get the UNDER-LINE in between the last row and the SUBFOOT ?

Maybe this will work for you:

TABLE FILE CAR
SUM DEALER_COST
RETAIL_COST
SALES
COMPUTE DUMMY/A1 = ''; NOPRINT
BY DUMMY NOPRINT
BY COUNTRY
HEADING
"WEBFOCUS REPORT HEADING"
ON DUMMY UNDER-LINE
ON TABLE SUBFOOT
"TOTAL<+0>TOT.DEALER_COST<+0>RETAIL_COST<+0>SALES"

ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
TYPE=REPORT, FONT='ARIAL', SIZE=8, GRID=OFF, STYLE=NORMAL,$
TYPE=TABFOOTING, HEADALIGN=BODY, FONT=ARIAL, SIZE=8, STYLE=BOLD, $
TYPE=SUBFOOT, LINE=1, ITEM=1, JUSTIFY=LEFT, POSITION=COUNTRY, $
TYPE=SUBFOOT, LINE=1, ITEM=2, JUSTIFY=RIGHT, POSITION=DEALER_COST, $
TYPE=SUBFOOT, LINE=1, ITEM=3, JUSTIFY=RIGHT, POSITION=RETAIL_COST, $
TYPE=SUBFOOT, LINE=1, ITEM=4, JUSTIFY=RIGHT, POSITION=SALES, $
TYPE=TABFOOTING, LINE=1, BORDER-TOP = LIGHT, $
ENDSTYLE
END

Thanks Francis for the Reply,

Using TABFOOTING instead of SUBFOOT made all the difference...