Hi How do i draw vertical lines between columns.I am using DB2-developer studio 7.6.4 -report painter- for both HTML and PDF reports.Do i need to write HTML code or Focus code.I searched forum, not getting any fruitful result. Thanks for the help, ramaThis message has been edited. Last edited by: Kerry,
WebFOCUS 762 Windows To be decided(All formats)
March 12, 2010, 10:46 AM
Prarie
Here's an easy way...
DEFINE FILE CAR LINE/A1 = '|'; END TABLE FILE CAR PRINT CAR LINE AS ' ' SEATS BY COUNTRY ON TABLE PCHOLD FORMAT PDF END
Here's another way
TABLE FILE CAR PRINT COUNTRY CAR MODEL ON TABLE SET STYLE * TYPE=DATA ,COLUMN=N1 ,BORDER-LEFT=OFF ,$ TYPE=DATA ,COLUMN=N2 ,BORDER-LEFT=ON ,$ TYPE=DATA ,COLUMN=N3 ,BORDER-LEFT=ON ,$ ENDSTYLE ON TABLE PCHOLD FORMAT PDF END
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
March 12, 2010, 10:47 AM
Dave
it's not really a line, but it's a great seperator in a report.
works in all formats...
COMPUTE SEP/A1 = ' '; AS ''
And give it's 'data' the same backgroundcolor as the lines or the background of the 'title'.
looks really nices...
g'luck.
_____________________ WF: 8.0.0.9 > going 8.2.0.5
March 12, 2010, 10:52 AM
Ram Prasad E
You can try VGRID=ON, here is a sample
TABLE FILE CAR PRINT COUNTRY CAR MODEL ON TABLE SET STYLE * TYPE=DATA ,COLUMN=N1 ,GRID=OFF ,$ TYPE=DATA ,COLUMN=N2 ,VGRID=ON ,$ ENDSTYLE ON TABLE PCHOLD FORMAT PDF END
Instead of HTML format use DHTML format to make use of the PDF styling.
TABLE FILE CAR
PRINT COUNTRY CAR MODEL
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF, $
TYPE=DATA ,COLUMN=N1 ,GRID=OFF ,$
TYPE=DATA ,COLUMN=N2 ,VGRID=ON ,$
ENDSTYLE
ON TABLE PCHOLD FORMAT DHTML
END
Prarie's second choice is my favourite one (using BORDER in style sheet).
It not only gives you more control over which columns should or shouldn't have the separating border but also allows you to adjust its style and width as well.
Best of all, it works "fine" for both PDF and HTML although with some limitations; you cannot have a vertical border between 2 columns in a SUBHEAD or SUBFOOT for example (at least not in PDF) but that may be also a limitation with any of the other approaches that have been provided.
Also available are BOX, STRING, and IMAGE. If you use hold format DHTML or PDF, the same syntax will work for both.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat