Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] Border in Excel causes blank line below heading
Go
New
Search
Notify
Tools
Reply
  
[CASE-OPENED] Border in Excel causes blank line below heading
 Login/Join
 
Virtuoso
posted
Has anyone ever figured out how to prevent the extra blank line/row that appears between the report heading and report body when using a border in EXL2K output?

SET DROPBLNKLINE = ON
-*
TABLE FILE CAR
 HEADING
  "Report from CAR Table"
 SUM
  DEALER_COST
  RETAIL_COST
 BY CAR
 ACROSS COUNTRY AS ''
 ON TABLE COLUMN-TOTAL
 ON TABLE PCHOLD FORMAT EXL2K
 ON TABLE SET STYLE *
  TYPE=REPORT, FONT='TREBUCHET MS', SIZE=10, COLOR=RGB(66 70 73), STYLE=NORMAL, ORIENTATION=LANDSCAPE, $
  TYPE=HEADING, STYLE=BOLD, SIZE=12, JUSTIFY=CENTER, $
  TYPE=REPORT, COLUMN=CAR, BORDER-RIGHT=LIGHT, $
 ENDSTYLE
END

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
<Kathryn Henning>
posted
Hi All,

Dan has a case opened for this, and I provided him with the following information which I also wanted to share on the forum.

The current implementation for SET DROPBLNKLINE = ON and HEADING is only for positioned formats such as PDF, PS, DHTML, and PPT when the request has a border or backcolor.

There is a New Feature Request in programming for SET DROPBLNKLINE = ON and HEADING support for all Excel formats. If you'd like to be included in the New Feature, please open a case on InfoResponse Online.

Thanks and regards,

Kathryn
 
Reply With QuoteReport This Post
Member
posted Hide Post
Hi Dan and Kathryn,

I am also having a similar problem with the space between report body and footer. Dan were u able to resolve this some other way.

Thanks!


WebFOCUS Version 8105
Windows, All Outputs
 
Posts: 4 | Registered: October 21, 2015Reply With QuoteReport This Post
Guru
posted Hide Post
Is there any new about this?

I am devolping a XLS report and user requested me to remove that line between heading and titles.

Thanks


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Master
posted Hide Post
Not a fix, but a possible workaround... the heading would need to be manually centered in Excel:

TABLE FILE CAR
 SUM
  DEALER_COST
  RETAIL_COST
 BY CAR
 ACROSS COUNTRY AS 'Report from CAR Table'
 ON TABLE COLUMN-TOTAL
 ON TABLE PCHOLD FORMAT EXL2K
 ON TABLE SET STYLE *
  TYPE=REPORT, FONT='TREBUCHET MS', SIZE=10, COLOR=RGB(66 70 73), STYLE=NORMAL, ORIENTATION=LANDSCAPE, $
  TYPE=HEADING, STYLE=BOLD, SIZE=12, JUSTIFY=CENTER, $
  TYPE=REPORT, COLUMN=CAR, BORDER-RIGHT=LIGHT, $
 ENDSTYLE
END


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Reply With QuoteReport This Post
Master
posted Hide Post
Have you tried using a template? I've never been able to get the borders in WebFOCUS to work like I want so I generally have a formatting template for reports that require special formatting.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 924 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] Border in Excel causes blank line below heading

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.