Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved] Footing Line
Go
New
Search
Notify
Tools
Reply
  
[Solved] Footing Line
 Login/Join
 
Silver Member
posted
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,


Release: Webfocus 7.6.11
OS/Platform: Windows
Output: HTML, EXL2K
 
Posts: 32 | Registered: October 29, 2010Reply With QuoteReport This Post
Guru
posted Hide Post
Take a look at
SET DROPBLNKLINE
This may be helpful.


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
 
Posts: 252 | Location: USA | Registered: April 15, 2003Reply With QuoteReport This Post
Guru
posted Hide Post
Can be achieved thorugh FOOTING BORDER and coressponding STYLING.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Reply With QuoteReport This Post
Silver Member
posted Hide Post
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


Release: Webfocus 7.6.11
OS/Platform: Windows
Output: HTML, EXL2K
 
Posts: 32 | Registered: October 29, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
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


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Silver Member
posted Hide Post
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,


Release: Webfocus 7.6.11
OS/Platform: Windows
Output: HTML, EXL2K
 
Posts: 32 | Registered: October 29, 2010Reply With QuoteReport This Post
Silver Member
posted Hide Post
Is there any way I can get the UNDER-LINE in between the last row and the SUBFOOT ?


Release: Webfocus 7.6.11
OS/Platform: Windows
Output: HTML, EXL2K
 
Posts: 32 | Registered: October 29, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
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


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thanks Francis for the Reply,

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


Release: Webfocus 7.6.11
OS/Platform: Windows
Output: HTML, EXL2K
 
Posts: 32 | Registered: October 29, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved] Footing Line

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.