[SOLVED] GRID=OFF adding unwanted blank spaces above report

September 03, 2009, 12:32 PM

How do I stop this happening? Heres my code:

TABLE FILE USAGE
FULL_USERNAME
EVENTS
ON TABLE HOLD AS NODERU04 FORMAT HTMTABLE
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
TYPE=REPORT,
GRID=OFF,
$
ENDSTYLE
END
-RUN

Which gives me this html with the unnecessary blank spaces:

<BODY>
<TABLE CELLPADDING=1>
<TR>
<TD NOWRAP COLSPAN=2>
 </TD>
</TR>
<TR>
<TD NOWRAP COLSPAN=2>
 </TD>
</TR>
<TR><TD NOWRAP COLSPAN=2>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="100%">
<TR>......

Thanks.

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

September 03, 2009, 12:43 PM

Francis Mariani

Try

ON TABLE SET PAGE-NUM NOLEAD

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 04, 2009, 06:06 AM

LEnderby

Hi Francis thanks but that hasnt worked I still have two empty table cells above my report. These disappear when I remove GRID=OFF but I want to remove the borders and I need the report at the top of the web page.

September 11, 2009, 05:03 PM

jnc

Hi LEnderby,

Here is my result with SET PAGE-NUM NOLEAD.
(it is pretty close to the top of the page.)

<TABLE CELLPADDING=1>
<TR>
<TD NOWRAP VALIGN=BOTTOM>
<U>COUNTRY</U></TD>
<TD NOWRAP ALIGN=RIGHT VALIGN=BOTTOM>
<U>SALES</U></TD>
</TR>
<TR>
<TD NOWRAP>
ENGLAND</TD>
<TD NOWRAP ALIGN=RIGHT>
12000</TD>
...snip.... (data removed to shorten)
</TABLE>

Here is the code I ran to get that result... 769.

TABLE FILE CAR
SUM SALES BY COUNTRY
ON TABLE HOLD AS NODERU04 FORMAT HTMTABLE
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET STYLE * 
TYPE=REPORT,GRID=OFF,$
ENDSTYLE
END
-HTMLFORM BEGIN
!IBI.FIL.NODERU04;
-HTMLFORM END

Another choice is to create a DEFINED field,
that has your exact HTML that you want.
That is the long way to get your result, but you'll get exactly what you're asking for.

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

September 11, 2009, 05:06 PM

jnc

I see my post got mangled...
In any case... try the focexec code.
because it has different (and I think shorter)
results than yours.

September 14, 2009, 11:32 AM

LEnderby

Thanks for your help its because I had SET LINES=99999 at the top. Take that out and it works.

October 26, 2009, 04:07 PM

jfr99

So........What if you need both:

ON TABLE SET PAGE NOLEAD
ON TABLE SET LINES 999999

Why doesn't this work? Is this a bug? Is there a work-around?

Let me know if someone has been able to get both of these to work in the same report.

Thanks
Jim

October 27, 2009, 10:08 AM

Francis Mariani

This is an ANNOYING "feature" of WebFOCUS. Anything higher than 998 causes the issue.

SET LINES=999 causing odd behavior

TABLE FILE CAR
SUM SALES BY COUNTRY
ON TABLE HOLD AS H001 FORMAT HTMTABLE
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET LINES 998
ON TABLE SET STYLE * 
TYPE=REPORT,GRID=OFF,$
ENDSTYLE
END
-HTMLFORM BEGIN
<html>
<body style="margin: 0px;">
!IBI.FIL.H001;
</style>
</html>
-HTMLFORM 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