Focal Point
[CLOSED]Extra blank row in the end of the report

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4507030386

July 08, 2016, 05:57 AM
Durai
[CLOSED]Extra blank row in the end of the report
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
July 08, 2016, 06:34 AM
Neelima
did you put the footing statement in the code.


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
July 08, 2016, 06:49 AM
Durai
Thank you for your reply Neelima. No,i did not.


Webfocus AppStudio 8201
Windows
July 08, 2016, 07:50 AM
Neelima
can you share the styling code?


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
July 08, 2016, 08:00 AM
Durai
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
July 08, 2016, 08:09 AM
Neelima
can you set HTMLCSS OFF in your code and try.


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
July 09, 2016, 11:01 AM
Durai
I tried by setting HTML CSS OFF it removes blank space but also styles of the report


Webfocus AppStudio 8201
Windows
July 09, 2016, 06:20 PM
Francis Mariani
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
July 11, 2016, 01:20 AM
Durai
I thank you very much for your reply Francis Mariani.

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


Webfocus AppStudio 8201
Windows
July 11, 2016, 04:19 AM
Neelima
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
July 11, 2016, 09:27 AM
Francis Mariani
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
July 13, 2016, 02:53 AM
Durai
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
September 15, 2016, 11:06 AM
Mike in DeLand
Take a look at this thread. It's about removing that last row.
http://forums.informationbuild...887013186#4887013186


Webfocus 8
Windows, Linux
September 15, 2016, 04:05 PM
capples
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
September 15, 2016, 04:31 PM
Francis Mariani
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
September 15, 2016, 04:46 PM
capples
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
February 20, 2017, 08:32 AM
Chaudhary
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
May 04, 2018, 02:14 PM
Shingles
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
May 04, 2018, 02:39 PM
Chaudhary
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
November 24, 2020, 06:02 PM
Brandon Andrathy
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