Focal Point
[CLOSED] ENABLING BORDER IN XLS REPORTS

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/353108353

January 27, 2010, 07:59 PM
krishkasi
[CLOSED] ENABLING BORDER IN XLS REPORTS
Hi,
We are moving from 7.1.4 to 7.6.9. In 7.6.9, while i am trying to enable the border, there is an extra blank line added to the header. Have any of you encountered similar problem. If you have a solution or a work around, please share it with me.

For reference I am giving the code below.

-*code without style
  
TABLE FILE CAR
PRINT 
CAR
BY COUNTRY
HEADING CENTER
"TEST"
ON TABLE SET ONLINE-FMT EXL2K
END



-*code witho style - Border enabled
  
TABLE FILE CAR
PRINT 
CAR
BY COUNTRY
HEADING CENTER
"TEST"
ON TABLE SET ONLINE-FMT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN = COUNTRY, BORDER-RIGHT=LIGHT,$
ENDSTYLE
END

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


Regards,
Kasi Krishnan
WF 7.1.4 & WF 7.6.9: Databases - DB2, SQL Server 2000.
OS: Windows & AIX
January 28, 2010, 01:17 PM
gweller
quote:
TABLE FILE CAR
PRINT
CAR
BY COUNTRY
HEADING CENTER
"TEST"
ON TABLE SET ONLINE-FMT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN = COUNTRY, BORDER-RIGHT=LIGHT,$
ENDSTYLE
END



I do not receive the same line...

I am assuming that you are not referring to the pagenum line that is added which can be removed using ON TABLE SET PAGE-NUM NOLEAD

?


WebFOCUS 8201M/Windows Platform