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 ENDThis message has been edited. Last edited by: <Kathryn Henning>,
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,
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.
WebFOCUS Version 8105
Windows, All Outputs
Is there any new about this?
I am devolping a XLS report and user requested me to remove that line between heading and titles.
WebFOCUS 8.1.05 / APP Studio
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
Windows, All Outputs
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.
|Powered by Social Strata|