[SOLVED]how to remove Extra 2 rows in html page

January 31, 2017, 08:36 AM

info4pal

Hi,

Iam using the below code and extra 2 unwanted html rows are getting generated
above the heading.i tried all the possibilities within Htmlform but nothing seems to be working.

Any help is greatly appreciated.

 DEFINE FILE CAR
FIRST_HEAD1/A20='subhead1';
SECOND_HEAD2/A10='subhead2';
A/A3='';
THIRD_HEAD3/A60='Target';
HEAD1/A15='>10%';
HEAD2/A15='>20%';
HEAD3/A15='>30%';
END

TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 30
HEADING
"Car heading"
"Source data"
"Data Current as of today"
" "
"<A<FIRST_HEAD1<SECOND_HEAD2<A<THIRD_HEAD3"
"<A<HEAD1<HEAD2<HEAD3"
ON TABLE HOLD AS HOLD_FILE FORMAT HTML
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS OFF
ON TABLE SET STYLE *
TYPE=REPORT,SQUEEZE=ON,FONT='ARIAL',SIZE=9,GRID=OFF,BORDER=1.5,TITLETEXT='Car report',$
TYPE=HEADING,HEADALIGN=BODY,$
TYPE=HEADING,LINE=1,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=10,STYLE=BOLD,$
TYPE=HEADING,LINE=2,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,$
TYPE=HEADING,LINE=3,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,$
TYPE=HEADING,LINE=4,COLSPAN=18,COLOR='BLACK',$
TYPE=HEADING,LINE=5,ITEM=1,COLSPAN=3,COLOR='BLACK',$
TYPE=HEADING,LINE=5,ITEM=2,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$
TYPE=HEADING,LINE=5,ITEM=3,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$
TYPE=HEADING,LINE=5,ITEM=4,COLSPAN=6,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,$
TYPE=HEADING,LINE=5,ITEM=5,COLSPAN=7,JUSTIFY=CENTER,COLOR=RGB(153 0 0),FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$
TYPE=HEADING,LINE=6,ITEM=1,COLSPAN=3,COLOR='BLACK',$
TYPE=HEADING,LINE=6,ITEM=2,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$
TYPE=HEADING,LINE=6,ITEM=3,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$
TYPE=HEADING,LINE=6,ITEM=4,COLSPAN=7,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$
TYPE=TITLE,FONT='ARIAL',SIZE=9,STYLE=-UNDERLINE,COLOR='BLACK',JUSTIFY=CENTER,BACKCOLOR=RGB(169 169 169),$
TYPE=DATA,FONT='ARIAL',SIZE=9,STYLE=NORMAL,JUSTIFY=LEFT,BORDER=ON,$
END
-RUN

-HTMLFORM BEGIN
<style>
table.empty {
  width: 350px;
  border-collapse: collapse;
  empty-cells: hide;
}
tr:empty {
  visibility: hidden;
}
table, th, td {
    border: 1px solid black;
	border-collapse: collapse;
	}
</style>
!IBI.FIL.HOLD_FILE;
-HTMLFORM END
-EXIT

Thanks,
IP

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

January 31, 2017, 08:46 AM

Prarie

Take a look at this thread.

space

February 01, 2017, 01:39 AM

info4pal

Hi Prarie,

That post talks about removing the blank line between the header and the title but that is not the issue Iam facing currently...

If you or anyone can run the car file,Iam getting 2 extra lines above the heading and Iam not sure on how to eliminate it.

Could anyone please help?

Thanks a lot in advance!

Regards,
IP

February 01, 2017, 02:30 AM

WF_IL

Hi

I have run your code and I don't see 2 extra lines above the heading, the html source:


<body>
<table cellpadding=1>
<tr>
<td NOWRAP colspan=18 align=CENTER>
<b><font FACE="ARIAL">Car heading</font></b></td></tr>
<tr>

I'm using 8105M December 2016 release

February 01, 2017, 02:33 AM

Dave

I don't get extra lines ( or I'm looking in the wrong place )

...
<title>Car report</title>
</head>
<body>
<table cellpadding=1>
<tr>
<td NOWRAP colspan=18 align=CENTER>
<b><font FACE="ARIAL">Car heading</font></b></td></tr>
<tr>
<td NOWRAP colspan=18 align=CENTER>
<b><i><font FACE="ARIAL" size=2>Source data</font></i></b></td></tr>
<tr>
....

February 01, 2017, 05:43 AM

info4pal

Hi,

WF_IL and Dave - With the car file,Iam not getting the extra 2 lines above the header however in my fex file,this is the html code(view source) which I got and it has "nbsp".A small chunk of the code upto the header is shown below:

 <style>
table.empty {
width: 350px;
border-collapse: collapse;
empty-cells: hide;
}
tr:empty {
visibility: hidden;
}
table, th, td {
border: 1px solid black;
	border-collapse: collapse;
	}
</style>
<!--Olap Javascript-->
<html>
<head>
<meta name="HandheldFriendly" content="True">
<meta name="PalmComputingPlatform" content="True">
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<title>Regional Core Overlapping Report</title>
</head>
<body>
<table cellpadding=1>
<tr>
<td NOWRAP colspan=17>
 </td>
</tr>
<tr>
<td NOWRAP colspan=17>
 </td>
</tr>
<tr>
<td NOWRAP colspan=17 align=CENTER>
[b]<font FACE="ARIAL">Report1</font>[/b]</td></tr>
<tr>

I tried removing the "nbsp" manually and running the report - fex file and it removes the extra 2 rows above the header but it removes the background color which I have applied for each of the data values under each column.

Is there any other to eliminate the "nbsp" in the code without affecting the color coding applied for the data and to remove the extra 2 rows above the header.

Please let me know.Thanks a lot in advance for all your help

Regards,
IP

February 01, 2017, 10:36 AM

WF_IL

Hi

Please post a repro on CAR, what is the difference between the fex you posted on CAR and the fex which causes this issue?

February 01, 2017, 02:26 PM

Prarie

Sorry, read your post wrong.

February 02, 2017, 08:37 AM

info4pal

Hi,

Only for one fex file which is under 1 specific folder,the report is working fine (without any extra 2 rows above the header) but in the rest of the fex files under different folders,Iam getting these extra 2 rows (empty ones) above the header.

Iam confused whether this is my code problem or some webfocus issue.

Please let me know your thoughts.

Regards,
IP

February 06, 2017, 11:46 AM

Tamra

info4pal,

Are all the fexes using the same HTML code?
Please post an example using the CAR file ( so we can try it ) using the HTML that is in your " other folders" that is displaying the extra 2 lines that you are seeing.

Compare the code in all your folders and see if there are any differences. Can you copy a focexec that is not working in one folder to the folder where the code is working and see what you get?

Thank you for participating in the Focal Point Forum!
Tamra Colangelo
Focal Point Moderator
Information Builders