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>,

did you put the footing statement in the code.

Thank you for your reply Neelima. No,i did not.

can you share the styling code?

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

can you set HTMLCSS OFF in your code and try.

I tried by setting HTML CSS OFF it removes blank space but also styles of the report

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.

I thank you very much for your reply Francis Mariani.

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

Hi Durai,

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

Thanks
Neelima

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

Thank you Francis.if you have example for treeview control please post me francis.

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

Take a look at this thread. It's about removing that last row.
http://forums.informationbuild...887013186#4887013186

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

Just be sure that if your data changes, that x6 doesn't become a different class!

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.

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
 

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!

Try these after the END command.

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