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>,

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

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!

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

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

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.