Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]how to remove Extra 2 rows in html page

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]how to remove Extra 2 rows in html page
 Login/Join
 
Guru
posted
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,


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Virtuoso
posted Hide Post
Take a look at this thread.

space
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Guru
posted Hide Post
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


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Platinum Member
posted Hide Post
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


Yours,
Eran
SRL Products

http://www.srl.co.il

 
Posts: 97 | Location: Tel Aviv, Israel | Registered: November 20, 2005Report This Post
Master
posted Hide Post
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>
....


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
Guru
posted Hide Post
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 Smiler

Regards,
IP


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Platinum Member
posted Hide Post
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?


Yours,
Eran
SRL Products

http://www.srl.co.il

 
Posts: 97 | Location: Tel Aviv, Israel | Registered: November 20, 2005Report This Post
Virtuoso
posted Hide Post
Sorry, read your post wrong. Music
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Guru
posted Hide Post
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


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Guru
posted Hide Post
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


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
Guru
posted Hide Post
Hi Tamra,

I had missed turning on GRID in the stylesheet.Now the reports are getting displayed without any extra lines/rows.

Thanks a lot everyone for your inputs on this Smiler

Regards,
IP


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]how to remove Extra 2 rows in html page

Copyright © 1996-2020 Information Builders