Focal Point
[CLOSED]Blank line between HEADING and Report with BODERs

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

February 17, 2012, 08:00 AM
Danny-SRL
[CLOSED]Blank line between HEADING and Report with BODERs
See the code:
  
TABLE FILE CAR
SUM 
     SALES
BY  LOWEST COUNTRY
HEADING
"Report"
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
$
ENDSTYLE
END

In the output there is a blank line between the HEADING and the report. This is caused by WebFOCUS inserting
  
<TD COLSPAN=2 class='x3'>&.nbsp;</TD>

after the heading in order to close the border around the HEADING.
Does anyone know a "simple" way to get rid of the blank line?


Ah well... I searched the Forum after I posted and saw the many requests... and still no solution...

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


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

February 17, 2012, 09:11 AM
njsden
quote:
.. and still no solution...

Sadly that's still the case. And I doubt they'll ever fix it as it may have an impact on many existing reports that have been developed expecting that line there.

It would be interesting to have something like:

SET BLANKAFTERHEADINGONBORDER = { OLD | NEW }

Where: OLD -> Annoying blank line
       NEW -> No blank line.  Consistent behaviour (border or no border)



The setting name should be shorter obviously, I'm just trying to make a point here Wink



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
February 17, 2012, 11:01 AM
Euclid
Would there be anyway to use jQuery and css like this?
Note: You have to clear out the cell text with javascript so the css will work.
<style type="text/css">
#requests{ empty-cells:hide; }
</style>

<script type="text/javascript">
     $("#requests :nth-child(2) td:first").text()
</script>

<table id="requests">
.
.
<tr>
<td>&.nbsp;</td>
</tr>
</table>


[U]References[/U]
http://www.w3schools.com/cssre..._tab_empty-cells.asp
http://stackoverflow.com/quest...ing-table-cells-text


Developer Studio 7.7.02
Windows XP Pro SP3 and Windows 7 64bit
all output
February 17, 2012, 12:13 PM
njsden
There are alternatives to work around the limitation in HTML but that would leave other formats (EXL2K, PDF, etc.) still facing the same issue.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
February 17, 2012, 01:04 PM
Norb Eckert
quote:
Where: OLD -> Annoying blank line


Yea - I'd like to see it in the documentation just like that! Pretty funny!


prod:7.6.9, win2k3 mre, caster, bid, devstudio 7.6.9
February 17, 2012, 01:31 PM
Euclid
@njsden
Very true, it would leave other formats with the spacing issue and your idea of SET BLANKAFTERHEADINGONBORDER = { OLD | NEW } is the best one. I am wondering if the gap is for a subheading?


Developer Studio 7.7.02
Windows XP Pro SP3 and Windows 7 64bit
all output
February 18, 2012, 01:23 PM
Danny-SRL
No. The gap is there to produce the bottom border of the HEADING as the top border of the gap. Was some programmer was a bit lazy?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

February 18, 2012, 02:58 PM
Danny-SRL
After some research. Using the same code in my first post, if we look at the generated HTML, this is what comes out. I changed all hard spaces to &.nbsp to see them. The offending blank is marked with ==>>:
  
<HTML>
<HEAD>
<META name="HandheldFriendly" content="True">
<META name="PalmComputingPlatform" content="True">
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<TITLE>WebFOCUS Report</TITLE>
<BASE HREF="http://localhost:8080/approot/focalpoint/">
<STYLE TYPE="text/css"> 
<!--
TABLE { border-collapse:collapse; }
TD { vertical-align:top; padding-left:6pt; padding-right:6pt; }
.x2 {
 border-style: NONE; }
.x3 {
 border-top: 1.00pt SOLID #000000; border-bottom: NONE; border-right: NONE; border-left: NONE; }
.x4 {
 border-top: 1.00pt SOLID #000000; border-bottom: NONE; border-right: NONE; border-left: 1.00pt SOLID #000000; }
.x1 {
 border-top: 1.00pt SOLID #000000; border-bottom: NONE; border-right: 1.00pt SOLID #000000; border-left: 1.00pt SOLID #000000; }
-->
</STYLE>
</HEAD>
<BODY>
<TABLE CELLPADDING=1>
<TR><TD style='padding-left:0pt' COLSPAN=2 class='x1'>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="100%">
<TR>
<TD class='x2'>
Report</TD>
</TR>
</TABLE></TD></TR>
<TR>
==>> <TD COLSPAN=2 class='x3'>&.nbsp;</TD>
</TR>
<TR>
<TD style="vertical-align:bottom" class='x4'>
COUNTRY</TD>
<TD ALIGN=RIGHT style="vertical-align:bottom" class='x1'>
SALES</TD>
</TR>
<TR>
<TD class='x4'>
ENGLAND</TD>
<TD ALIGN=RIGHT class='x1'>
12000</TD>
</TR>
<TR>
<TD class='x4'>
FRANCE</TD>
<TD ALIGN=RIGHT class='x1'>
0</TD>
</TR>
<TR>
<TD class='x4'>
ITALY</TD>
<TD ALIGN=RIGHT class='x1'>
30200</TD>
</TR>
<TR>
<TD class='x4'>
JAPAN</TD>
<TD ALIGN=RIGHT class='x1'>
78030</TD>
</TR>
<TR>
<TD class='x4'>
W GERMANY</TD>
<TD ALIGN=RIGHT class='x1'>
88190</TD>
</TR>
<TR>
<TD  class='x3'>&.nbsp;</TD>
<TD  class='x3'>&.nbsp;</TD>
</TR>
</TABLE>
</BODY>
</HTML>

You will notice that if one takes out the offending line, then the output is just as we would like it.
So? Where is the problem? Can't the SET as proposed by njsden be added?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

August 30, 2016, 10:30 AM
David Briars
quote:
...It would be interesting to have something like:

SET BLANKAFTERHEADINGONBORDER = { OLD | NEW }

Where: OLD -> Annoying blank line
NEW -> No blank line. Consistent behaviour (border or no border)


We are planning to upgrade from 8007 to 8105M, and have 8105M in a PILOT environment.

Searched the 8105M 'New Features' manual for a fix to the blank line between the HEADING and ColumnTitles, in high hopes, but no joy.

In 8.1 the offending blank line now has a class of 'x4' instead of 'x3'.

For example, when you run Danny's excellent example showing the issue, in the first post, you now see the following HTTML tag insert:
<td colspan=2 class='x4'>
 </td> 

So...if you were responsive to your users who didn't like the blank line, and hid 'x3' with CSS, you might need to consider remediation.

(If I am missing something, and there is a solution, I am all ears!)




Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster