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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Extra blank row in the end of the report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]Extra blank row in the end of the report
 Login/Join
 
Gold member
posted
while running a report it creates extra blank row in the end of the Report.I tried by setting ON TABLE SET HTMLCSS OFF while the blank row in the end of the report does not appear but also it hides the styles applied in the report.Please help me to solve out this problem.

This message has been edited. Last edited by: <Emily McAllister>,


Webfocus AppStudio 8201
Windows
 
Posts: 53 | Registered: May 09, 2016Report This Post
Platinum Member
posted Hide Post
did you put the footing statement in the code.


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 186 | Location: INDIA | Registered: July 11, 2013Report This Post
Gold member
posted Hide Post
Thank you for your reply Neelima. No,i did not.


Webfocus AppStudio 8201
Windows
 
Posts: 53 | Registered: May 09, 2016Report This Post
Platinum Member
posted Hide Post
can you share the styling code?


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 186 | Location: INDIA | Registered: July 11, 2013Report This Post
Gold member
posted Hide Post
This is my styling code

ON TABLE SET STYLE *
SQUEEZE = ON,
$
TYPE=REPORT,
BORDER-TOP=ON,
BORDER-BOTTOM=ON,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
JUSTIFY=CENTER,
BACKCOLOR=WHITE,
$
TYPE=DATA,
COLUMN=N2,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-TOP-COLOR='SILVER',
BORDER-BOTTOM-COLOR='SILVER',
BORDER-LEFT-COLOR='SILVER',
BORDER-RIGHT-COLOR='SILVER',
SQUEEZE=2,
$
TYPE=DATA,
COLUMN=N3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR='SILVER',
BORDER-BOTTOM-COLOR='SILVER',
BORDER-LEFT-COLOR='SILVER',
BORDER-RIGHT-COLOR='SILVER',
SQUEEZE=4,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-TOP-COLOR='SILVER',
BORDER-BOTTOM-COLOR='SILVER',
BORDER-LEFT-COLOR='SILVER',
BORDER-RIGHT-COLOR='SILVER',
SQUEEZE=1,
$
TYPE=TITLE,
FONT='ARIAL',
SIZE=12,
COLOR='WHITE',
BACKCOLOR=RGB(0 151 186),
$
TYPE=TITLE,
COLUMN=N2,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR='SILVER',
BORDER-BOTTOM-COLOR='SILVER',
BORDER-LEFT-COLOR='SILVER',
BORDER-RIGHT-COLOR='SILVER',
$
TYPE=TITLE,
COLUMN=N3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR='SILVER',
BORDER-BOTTOM-COLOR='SILVER',
BORDER-LEFT-COLOR='SILVER',
BORDER-RIGHT-COLOR='SILVER',
$
TYPE=TITLE,
COLUMN=N1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR='SILVER',
BORDER-BOTTOM-COLOR='SILVER',
BORDER-LEFT-COLOR='SILVER',
BORDER-RIGHT-COLOR='SILVER',
$
TYPE=REPORT,
COLUMN=N3,
BORDER-RIGHT=ON,
$
TYPE=REPORT,
COLUMN=N1,
BORDER-LEFT=ON,
$
ENDSTYLE
END


Webfocus AppStudio 8201
Windows
 
Posts: 53 | Registered: May 09, 2016Report This Post
Platinum Member
posted Hide Post
can you set HTMLCSS OFF in your code and try.


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 186 | Location: INDIA | Registered: July 11, 2013Report This Post
Gold member
posted Hide Post
I tried by setting HTML CSS OFF it removes blank space but also styles of the report


Webfocus AppStudio 8201
Windows
 
Posts: 53 | Registered: May 09, 2016Report This Post
Expert
posted Hide Post
This is an ages-old problem - the last row is used to create the bottom border for the real last report row - for HTML reports, WebFOCUS needs the <TR> and <TD> to generate the bottom border. It's ridiculous, but there's nothing you can do.


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
Gold member
posted Hide Post
I thank you very much for your reply Francis Mariani.

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


Webfocus AppStudio 8201
Windows
 
Posts: 53 | Registered: May 09, 2016Report This Post
Platinum Member
posted Hide Post
Hi Durai,

Could you please replicate your issue on sample car master file. It would be good for me.

Thanks
Neelima


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 186 | Location: INDIA | Registered: July 11, 2013Report This Post
Expert
posted Hide Post
Here is an example that illustrates the issue in an HTML report. You have to hold down the mouse button and drag to the bottom to see the effect.

It has everything to do with HTMLCSS ON and BORDER. I have taken the liberty to undo the unnecessary repetition of the GUI Reporting tool.

TABLE FILE CAR
SUM
SALES

BY COUNTRY 
BY CAR 

ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE = ON, BORDER=ON, BORDER-BOTTOM=ON, BORDER-LEFT=OFF, BORDER-RIGHT=OFF, JUSTIFY=CENTER, BACKCOLOR=WHITE, $
TYPE=DATA, COLUMN=N2,  BORDER=LIGHT, BORDER-COLOR='SILVER', SQUEEZE=2, $
TYPE=DATA, COLUMN=N3,  BORDER=LIGHT, BORDER-COLOR='SILVER', SQUEEZE=4, JUSTIFY=LEFT, $
TYPE=DATA, COLUMN=N1,  BORDER=LIGHT, BORDER-COLOR='SILVER',SQUEEZE=1, $
TYPE=TITLE, FONT='ARIAL', SIZE=12, COLOR='WHITE', BACKCOLOR=RGB(0 151 186), $
TYPE=TITLE, COLUMN=N2,  BORDER=LIGHT, BORDER-COLOR='SILVER', $
TYPE=TITLE, COLUMN=N3,  BORDER=LIGHT, BORDER-COLOR='SILVER', $
TYPE=TITLE, COLUMN=N1,  BORDER=LIGHT, BORDER-COLOR='SILVER', $
TYPE=REPORT, COLUMN=N3, BORDER-RIGHT=ON, $
TYPE=REPORT, COLUMN=N1, BORDER-LEFT=ON, $
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
Gold member
posted Hide Post
Thank you Francis.if you have example for treeview control please post me francis.

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


Webfocus AppStudio 8201
Windows
 
Posts: 53 | Registered: May 09, 2016Report This Post
Guru
posted Hide Post
Take a look at this thread. It's about removing that last row.
http://forums.informationbuild...887013186#4887013186


Webfocus 8
Windows, Linux
 
Posts: 258 | Location: Palm Coast, FL | Registered: February 05, 2010Report This Post
Gold member
posted Hide Post
Just wanted to say thanks for posting that link. This has been my bothering me for a while when trying to size reports and this blank line creates scroll bars that are not needed.

For others that might search and find this, you can inspect the element to determine the CSS class for the blank line at the bottom of the report (it's been something like .x6 or .x7 or some variant in my cases). You can then add this block of code at the end of your procedure to remove this element(I add it above the last END but below the ENDSTYLE). Hope this helps

ENDSTYLE


-HTMLFORM BEGIN
<html>
<head>
<style>
.x6 {
display:none;
}
</style>
</head>
</html>
-HTMLFORM END

END


WF 8.2.0.3
Windows 10 64bit
HTML, AHTML, PDF, Excel
 
Posts: 83 | Registered: April 13, 2015Report This Post
Expert
posted Hide Post
Just be sure that if your data changes, that x6 doesn't become a different class!


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
Gold member
posted Hide Post
Good point Francis, we just ran across this when someone tried to run one of the fexes with Message Viewer on as it caused the classes to change.

I think we'll mostly be using this on pages where the layout won't be changing in order to get the exact styling we want.


WF 8.2.0.3
Windows 10 64bit
HTML, AHTML, PDF, Excel
 
Posts: 83 | Registered: April 13, 2015Report This Post
Platinum Member
posted Hide Post
so we can make tables's last row as "display none"
 -HTMLFORM BEGIN
<script>
var sheet = document.createElement('style')
sheet.innerHTML = "table tr:last-child {display:none;}";
document.body.appendChild(sheet);
</script>
-HTMLFORM END
 


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
 
Posts: 186 | Location: Infobuild India | Registered: August 28, 2015Report This Post
Platinum Member
posted Hide Post
Hi Folks,
Rehashing an old one here... I can't seem to get this to work. I still get that blank line. I've tried both of Chaudhary and capples variants.

Should the HTMLFORM bit (the code in Chaudhary and capples post above) be placed after the END command of the TABLE or before it? I don't think it should matter.

Thank you!


WebFOCUS 8201, SP 0.1, Windows 7, HTML
 
Posts: 190 | Registered: May 19, 2017Report This Post
Platinum Member
posted Hide Post
Try these after the END command.


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
 
Posts: 186 | Location: Infobuild India | Registered: August 28, 2015Report This Post
Platinum Member
posted Hide Post
Since REMOVING THE BLANK LINE BETWEEN A REPORT AND FOOTER is crazy painful, also sharing this works with other CSS Selectors. I used "nth-last-child(2)" instead of last-child. Thanks a lot!

 

-HTMLFORM BEGIN
<script>
var sheet = document.createElement('style')
sheet.innerHTML = "table tr:nth-last-child(2) {display:none;}";
document.body.appendChild(sheet);
</script>
	<style>
        body{ overflow-y: hidden;
			  margin-right: 30px;
			  margin-bottom: 100px;
			  border-style: none;
			}
    </style>
-HTMLFORM END

 


WebFOCUS 8204
 
Posts: 152 | Registered: July 10, 2018Report 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     [CLOSED]Extra blank row in the end of the report

Copyright © 1996-2020 Information Builders