nbsp; at the bottom of each report request.

August 22, 2008, 09:25 AM

Srinivasan_Munuswamy

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,

August 22, 2008, 09:29 AM

GinnyJakes

Srini,

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

August 22, 2008, 09:31 AM

Srinivasan_Munuswamy

Thanks Ginny,
Now code is coming in the message

August 22, 2008, 10:05 AM

GinnyJakes

I meant your source WF code so we can see what generated the html.

August 22, 2008, 10:23 AM

Srinivasan_Munuswamy

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

August 22, 2008, 11:05 AM

Srinivasan_Munuswamy

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

August 22, 2008, 01:10 PM

Bhanu

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

August 22, 2008, 01:25 PM

Bhanu

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

August 22, 2008, 01:29 PM

Bhanu

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

August 22, 2008, 06:06 PM

susannah

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!

August 25, 2008, 09:58 AM

PBrightwell

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

I would recommend you remove this line.

August 25, 2008, 12:28 PM

Francis Mariani

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.