Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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, 2010Report 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, 2003Report 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, 2009Report 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, 2010Report 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, 2005Report 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, 2010Report 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, 2010Report 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, 2005Report 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, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders