[CLOSED]Blank line between HEADING and Report with BODERs

  
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

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

njsden

Virtuoso

posted

Hide Post

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

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.

Posts: 1533 | Registered: August 12, 2005

Ignored post by njsden posted

Show Post

Euclid

Member

posted

Hide Post

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

Posts: 20 | Registered: January 27, 2010

Ignored post by Euclid posted

Show Post

njsden

Virtuoso

posted

Hide Post

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.

Posts: 1533 | Registered: August 12, 2005

Ignored post by njsden posted

Show Post

Norb Eckert

Platinum Member

posted

Hide Post

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

Posts: 242 | Location: Minneapolis | Registered: February 16, 2006

Ignored post by Norb Eckert posted

Show Post

Euclid

Member

posted

Hide Post

@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

Posts: 20 | Registered: January 27, 2010

Ignored post by Euclid posted

Show Post

Danny-SRL

Virtuoso

posted

Hide Post

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

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

Show Post

Danny-SRL

Virtuoso

posted

Hide Post

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

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

Show Post

David Briars

Master

posted

Hide Post

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

Posts: 822 | Registered: April 23, 2003

Ignored post by David Briars posted

Show Post

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

[CLOSED]Blank line between HEADING and Report with BODERs

Focal Point | Privacy Statement | Terms of Service