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     nbsp; at the bottom of each report request.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
nbsp; at the bottom of each report request.
 Login/Join
 
Srinivasan_Munuswamy
Gold member
posted
Hi All,

I have a report which is printing 3-4 colums, at the end of the report bottom a small space is coming. Is there a way to turn of this unnecessary   TR which is creating the space at the bottom of the reports.
  <TR><TD  class='x31'>&|nbsp;</TD><TD  class='x32'>&|nbsp;</TD></TR></TABLE></BODY></HTML>

I want to remove space at the bottom of report.
Please help me in this.
Thanks & Regards,
SrinivasanM

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


WF 8.0.0.9 Database : oracle

CURRENT:
WebFOCUS 8.0.0.9 /oracle 11 i

 
Posts: 51 | Registered: September 20, 2007Report This Post
GinnyJakes
Expert
posted Hide Post
Srini,

Please post your code between code tags, last icon in the reply window.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Srinivasan_Munuswamy
Gold member
posted Hide Post
Thanks Ginny,
Now code is coming in the message


WF 8.0.0.9 Database : oracle

CURRENT:
WebFOCUS 8.0.0.9 /oracle 11 i

 
Posts: 51 | Registered: September 20, 2007Report This Post
GinnyJakes
Expert
posted Hide Post
I meant your source WF code so we can see what generated the html.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Srinivasan_Munuswamy
Gold member
posted Hide Post
quote:
meant your source WF code so we can see what generated the html


-INCLUDE common/common1
-*DEFAULT &FUNDCODE = 'PI003'
-*-SET &&FUNDCODE = &FUNDCODE;

-INCLUDE common/connection
-INCLUDE nf10020
TABLE FILE SQLOUT
PRINT
*
ON TABLE HOLD
END
-INCLUDE common/norecords
TABLE FILE HOLD
PRINT
AMC_NAME AS 'Fund House' OVER
CDSC OVER
FUND_ASSET_CLASS AS 'Fund Type' OVER
FUND_CATGRY AS 'Fund Category' OVER
FUND_NATURE AS 'Fund Nature' OVER
NFO_LAUNCH_DT AS 'Launch Date' OVER
NFO_CLSD_DT AS 'Close Date' OVER
PLAN AS 'Plans' OVER
FUND_OPTION AS 'Options' OVER
BNCHMK_NAME AS 'Benchmark' OVER
MIN_INVMT/P17 AS 'Min. investment' OVER
MIN_SIP_INVMT/P17 AS 'Min. SIP Investment' OVER
ENTRY/P12.2% AS 'Entry Load' OVER
EXIT/P12.2% AS 'Exit Load' OVER
EXPENSE_RATIO AS 'Expense Ratio'
WHERE RECORDLIMIT EQ 1
ON TABLE NOTOTAL
ON TABLE SET PAGE NOPAGE
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET CSSURL '/ibi_html/css/nfo.css'
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='VERDANA',
SIZE=10,
RIGHTGAP=.609,
$
TYPE=DATA,
COLUMN=N15,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,

BORDER-TOP-COLOR=RGB(183 219 255),
BORDER-BOTTOM-COLOR=RGB(183 219 255),
BORDER-LEFT-COLOR=RGB(183 219 255),
BORDER-RIGHT-COLOR=RGB(183 219 255),
JUSTIFY=LEFT,
BACKCOLOR=RGB(222 237 253),
$
TYPE=DATA,
COLUMN=N14,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,

BORDER-TOP-COLOR=RGB(183 219 255),
BORDER-BOTTOM-COLOR=RGB(183 219 255),
BORDER-LEFT-COLOR=RGB(183 219 255),
BORDER-RIGHT-COLOR=RGB(183 219 255),
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N13,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,

BORDER-TOP-COLOR=RGB(183 219 255),
BORDER-BOTTOM-COLOR=RGB(183 219 255),
BORDER-LEFT-COLOR=RGB(183 219 255),
BORDER-RIGHT-COLOR=RGB(183 219 255),
JUSTIFY=LEFT,
BACKCOLOR= RGB(222 237 253),
$
TYPE=DATA,
COLUMN=N12,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,

BORDER-TOP-COLOR=RGB(183 219 255),
BORDER-BOTTOM-COLOR=RGB(183 219 255),
BORDER-LEFT-COLOR=RGB(183 219 255),
BORDER-RIGHT-COLOR=RGB(183 219 255),
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,

BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
URL=d:\abc,
BACKCOLOR= RGB(222 237 253),
$
TYPE=DATA,
COLUMN=N2,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,

BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
BACKCOLOR= RGB(222 237 253),
$
TYPE=DATA,
COLUMN=N4,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N5,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
BACKCOLOR= RGB(222 237 253),
$
TYPE=DATA,
COLUMN=N6,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,

BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N7,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,

BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
BACKCOLOR= RGB(222 237 253),
$
TYPE=DATA,
COLUMN=N8,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,

BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N9,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,

BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
BACKCOLOR= RGB(222 237 253),
$
TYPE=DATA,
COLUMN=N10,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,

BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N11,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,

BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
BACKCOLOR= RGB(222 237 253),
$
TYPE=TITLE,
COLUMN=N15,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,

BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
JUSTIFY=LEFT,
BACKCOLOR=RGB(222 237 253),
$
TYPE=TITLE,
COLUMN=N14,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,

BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N13,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
BACKCOLOR= RGB(222 237 253),

$
TYPE=TITLE,
COLUMN=N12,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,

BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
BACKCOLOR= RGB(222 237 253),
$
TYPE=TITLE,
COLUMN=N2,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
BACKCOLOR= RGB(222 237 253),
$
TYPE=TITLE,
COLUMN=N4,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,

BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N5,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,

BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
BACKCOLOR= RGB(222 237 253),
$
TYPE=TITLE,
COLUMN=N6,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,

BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N7,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,

BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
BACKCOLOR= RGB(222 237 253),
$
TYPE=TITLE,
COLUMN=N8,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,

BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N9,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,

BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
BACKCOLOR= RGB(222 237 253),
$
TYPE=TITLE,
COLUMN=N10,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,

BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,

$
TYPE=TITLE,
COLUMN=N11,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,

BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(153 204 255),
BORDER-BOTTOM-COLOR=RGB(153 204 255),
BORDER-LEFT-COLOR=RGB(153 204 255),
BORDER-RIGHT-COLOR=RGB(153 204 255),
FONT='VERDANA',
JUSTIFY=LEFT,
BACKCOLOR= RGB(222 237 253),

$
TYPE=SUBFOOT, BY=NBSP, OBJECT=FIELD, ITEM=1, JUSTIFY=LEFT, STYLE=BOLD, FONT='ARIAL',$


ENDSTYLE
END


WF 8.0.0.9 Database : oracle

CURRENT:
WebFOCUS 8.0.0.9 /oracle 11 i

 
Posts: 51 | Registered: September 20, 2007Report This Post
Srinivasan_Munuswamy
Gold member
posted Hide Post
Hi All,
When I remove all the css and create the report nbsp is being removed and I also found moment I apply BORDER-TOP-COLOR=RGB(153 204 255),
or anything related to BORDER it is automatically creating a blank space at the end of the report.
Is there a way to specify the borders within webfocus?

-INCLUDE common/common1
-INCLUDE common/connection
-INCLUDE nf10020
TABLE FILE SQLOUT
PRINT
*
ON TABLE HOLD
END
-INCLUDE common/norecords
TABLE FILE HOLD
PRINT
AMC_NAME AS 'Fund House' OVER
CDSC OVER
FUND_ASSET_CLASS AS 'Fund Type' OVER
FUND_CATGRY AS 'Fund Category' OVER
FUND_NATURE AS 'Fund Nature' OVER
NFO_LAUNCH_DT AS 'Launch Date' OVER
NFO_CLSD_DT AS 'Close Date' OVER
PLAN AS 'Plans' OVER
FUND_OPTION AS 'Options' OVER
BNCHMK_NAME AS 'Benchmark' OVER
MIN_INVMT/P17 AS 'Min. investment' OVER
MIN_SIP_INVMT/P17 AS 'Min. SIP Investment' OVER
ENTRY/P12.2% AS 'Entry Load' OVER
EXIT/P12.2% AS 'Exit Load' OVER
EXPENSE_RATIO AS 'Expense Ratio'
WHERE RECORDLIMIT EQ 1
ON TABLE NOTOTAL
ON TABLE SET PAGE NOPAGE
ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET CSSURL '/ibi_html/css/nfo.css'
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=TITLE,
COLUMN=N1,
JUSTIFY=LEFT,


BACKCOLOR= RGB(222 237 253),
$
ENDSTYLE
END


WF 8.0.0.9 Database : oracle

CURRENT:
WebFOCUS 8.0.0.9 /oracle 11 i

 
Posts: 51 | Registered: September 20, 2007Report This Post
Bhanu
Member
posted Hide Post
Srini,

Tried for the symptom and could not re-produce the issue you were reporting.

Eg:
TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 1
ON TABLE NOTOTAL
ON TABLE SET PAGE NOPAGE
ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET CSSURL '/ibi_html/css/nfo.css'
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=TITLE,
COLUMN=N1,
JUSTIFY=LEFT,


BACKCOLOR= RGB(222 237 253),
$
ENDSTYLE
END
-EXIT
The view source is




WebFOCUS Report














































COUNTRY
CAR
MODEL
BODYTYPE
SEATS
DEALER_COST
RETAIL_COST
SALES
LENGTH
WIDTH
HEIGHT
WEIGHT
WHEELBASE
FUEL_CAP
BHP
RPM
MPG
ACCEL

ENGLAND
JAGUAR
V12XKE AUTO
CONVERTIBLE
2
7,427
8,878
0
190
66
48
3,435
105.0
18.0
241
5750
16
7



< !--
(FOC757) WARNING. YOU REQUESTED PRINT * OR COUNT * FOR A MULTIPATH FILE
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
0 HOLDING HTML FILE ON PC DISK ...

WebFOCUS Version 7.6.4 compiled and linked on Tue Apr 1 12:50:30 EDT 2008 (Gen branch764_hotfix:37)
-->

Eg2:
TABLE FILE CAR
PRINT *
WHERE RECORDLIMIT EQ 1
END
-EXIT




WebFOCUS Report

















































PAGE 1

COUNTRY
CAR
MODEL
BODYTYPE
SEATS
DEALER_COST
RETAIL_COST
SALES
LENGTH
WIDTH
HEIGHT
WEIGHT
WHEELBASE
FUEL_CAP
BHP
RPM
MPG
ACCEL

ENGLAND
JAGUAR
V12XKE AUTO
CONVERTIBLE
2
7,427
8,878
0
190
66
48
3,435
105.0
18.0
241
5750
16
7



< !--
(FOC757) WARNING. YOU REQUESTED PRINT * OR COUNT * FOR A MULTIPATH FILE
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1

WebFOCUS Version 7.6.4 compiled and linked on Tue Apr 1 12:50:30 EDT 2008 (Gen branch764_hotfix:37)
-->

Output For both:
You can run the same code and in your env and if it behavfes differently.

Bhanu
 
Posts: 8 | Registered: January 25, 2007Report This Post
Bhanu
Member
posted Hide Post
Srini,

OK, the issue is with the
ON TABLE SET HTMLCSS ON

command.

If you comment or make it OFF the extra line goes off. Comment this line and see if this works for you.

Bhanu
 
Posts: 8 | Registered: January 25, 2007Report This Post
Bhanu
Member
posted Hide Post
The Only diff I oberserved in the output is the GRID, so

ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
GRID=ON,
$
Bhanu
 
Posts: 8 | Registered: January 25, 2007Report This Post
susannah
Expert
posted Hide Post
Bhanu
edit your post and but your fex code within code tags...just as Ginny said...
do it now.
the code tags are the rightmost (in red) icon at the top of this edit panel.
you'll surround your code with something like
[ code]
...
[ /code]
Do it now!



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
PBrightwell
Master
posted Hide Post
quote:
TYPE=SUBFOOT, BY=NBSP, OBJECT=FIELD, ITEM=1, JUSTIFY=LEFT, STYLE=BOLD, FONT='ARIAL',$


I would recommend you remove this line.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
ON TABLE SET HTMLCSS ON
ON TABLE SET CSSURL '/ibi_html/css/nfo.css'


I avoid that combination like the Plague. I use either SET HTMLCSS ON or CSSURL but not both.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report 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     nbsp; at the bottom of each report request.

Copyright © 1996-2020 Information Builders