When running a report in excel format, is there a way to turn off the grid lines in excel? Preferably without creating an excel template.
The report I am running would look much cleaner if they weren't there.
Thanks in advance for any assistance anyone can offer.This message has been edited. Last edited by: Kerry,
WebFOCUS 8008 Windows, All Outputs
December 14, 2010, 02:58 PM
Dan Satchell
A possible workaround?
TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF, $
ENDSTYLE
ON TABLE HOLD FORMAT HTMTABLE
END
-*
SET HTMLFORMTYPE=XLS
-RUN
-*
-HTMLFORM BEGIN
!IBI.FIL.HOLD ;
-HTMLFORM END
WebFOCUS 7.7.05
December 15, 2010, 08:04 AM
jhasty
Thanks Dan - this looks like it might work. One thing I neglected to mention though is that the report I am running is a compound report where I am outputting to 3 separate tabs. Would like to turn the grid lines off on all three tabs if possible.
Any thoughts on how to implement what you suggested above with the use of compound reports?
WebFOCUS 8008 Windows, All Outputs
December 15, 2010, 10:13 AM
Francis Mariani
According to the WebFOCUS New Features v7.6.9 document, you can play with borders in EXL2K formatted reports:
quote:
Excel (EXL2K Format) Style Enhancements The StyleSheet options ORIENTATION=LANDSCAPE and BORDER=ON are now supported for EXL2K report output. The BORDER attribute supports the same options as currently available for FORMAT PDF except for border options available in Adobe PDF but not available in Microsoft Excel
Unfortunately I can't test this, we have v7.6.8.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 15, 2010, 02:56 PM
Hua
If you don't mind applying a background color, will automatically give you gridless report.
TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
ON TABLE SET STYLE *
TYPE=REPORT, BACKCOLOR=YELLOW, $
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END
Developer Studio 7.6.11 AS400 - V5R4 HTML,PDF,XLS
December 16, 2010, 10:00 AM
BobV
I use background color = white
ON TABLE SET STYLE * TYPE=REPORT, BACKCOLOR=WHITE, $ ENDSTYLE
I often use it at the column level rather than the whole report. That way I still have grids in headers, footers, titles etc
WF (App Studio) 8.2.01m / Windows Mainframe FOCUS 8