Focal Point
[SOLVED] Inconsistent borders on column headings

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/207109441

June 09, 2009, 09:40 AM
Mark
[SOLVED] Inconsistent borders on column headings
Please see following code. I have created a report with standard headings that should have light blue borders around the column headings. On page 1 there are no lower borders at all. Then on pages 2 - 6 the only lower border is on the REGION heading but skips a line before displaying it. How can I have the borders on all column headings and without skipping lines?

-* File carsales.fex
SET LINES = 66
TABLE FILE GGSALES
SUM
UNITS
BY REGION
BY ST
BY CITY
BY PRODUCT
ON REGION SUBTOTAL AS '*TOTAL REGION'
ON ST SUBTOTAL AS '*TOTAL'
ON CITY SUBTOTAL AS '*TOTAL CITY'
ON PRODUCT SUBFOOT WITHIN
" "
HEADING
"Page ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE GGSALES.SALES01.UNITS AS 'TOTAL'
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
INCLUDE = PROBLUE,
$
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=N2 EQ 'IL',
$
DEFMACRO=COND0002,
MACTYPE=RULE,
WHEN=N2 EQ 'MO',
$
TYPE=REPORT,
BORDER-TOP-STYLE=RIDGE,
BORDER-BOTTOM-STYLE=RIDGE,
BORDER-LEFT-STYLE=RIDGE,
BORDER-RIGHT-STYLE=RIDGE,
BORDER-TOP-COLOR=RGB(51 51 153),
BORDER-BOTTOM-COLOR=RGB(51 51 153),
BORDER-LEFT-COLOR=RGB(51 51 153),
BORDER-RIGHT-COLOR=RGB(51 51 153),
FONT='TIMES NEW ROMAN',
SIZE=10,
RIGHTGAP=0.125000,
$
TYPE=DATA,
COLUMN=N1,
FONT='TIMES NEW ROMAN',
SIZE=8,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N2,
FONT='TIMES NEW ROMAN',
SIZE=8,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N3,
FONT='TIMES NEW ROMAN',
SIZE=8,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N4,
FONT='TIMES NEW ROMAN',
SIZE=8,
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N5,
FONT='TIMES NEW ROMAN',
SIZE=8,
STYLE=NORMAL,
$
TYPE=TITLE,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-STYLE=RIDGE,
BORDER-BOTTOM-STYLE=RIDGE,
BORDER-LEFT-STYLE=RIDGE,
BORDER-RIGHT-STYLE=RIDGE,
BORDER-TOP-COLOR=RGB(51 51 153),
BORDER-BOTTOM-COLOR=RGB(51 51 153),
BORDER-LEFT-COLOR=RGB(51 51 153),
BORDER-RIGHT-COLOR=RGB(51 51 153),
$
TYPE=TITLE,
COLUMN=N1,
FONT='TIMES NEW ROMAN',
SIZE=8,
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N2,
FONT='TIMES NEW ROMAN',
SIZE=8,
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N3,
FONT='TIMES NEW ROMAN',
SIZE=8,
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N4,
FONT='TIMES NEW ROMAN',
SIZE=8,
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N5,
FONT='TIMES NEW ROMAN',
SIZE=8,
STYLE=NORMAL,
$
TYPE=FOOTING,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-STYLE=RIDGE,
BORDER-BOTTOM-STYLE=RIDGE,
BORDER-LEFT-STYLE=RIDGE,
BORDER-RIGHT-STYLE=RIDGE,
BORDER-TOP-COLOR=RGB(51 51 153),
BORDER-BOTTOM-COLOR=RGB(51 51 153),
BORDER-LEFT-COLOR=RGB(51 51 153),
BORDER-RIGHT-COLOR=RGB(51 51 153),
$
TYPE=SUBFOOT,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-STYLE=RIDGE,
BORDER-BOTTOM-STYLE=RIDGE,
BORDER-LEFT-STYLE=RIDGE,
BORDER-RIGHT-STYLE=RIDGE,
BORDER-TOP-COLOR=RGB(51 51 153),
BORDER-BOTTOM-COLOR=RGB(51 51 153),
BORDER-LEFT-COLOR=RGB(51 51 153),
BORDER-RIGHT-COLOR=RGB(51 51 153),
$
TYPE=SUBFOOT,
BY=4,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
BACKCOLOR='NONE',
$
TYPE=SUBTOTAL,
BY=1,
BACKCOLOR=RGB(210 210 210),
$
TYPE=SUBTOTAL,
BY=2,
BACKCOLOR=RGB(210 210 210),
$
TYPE=SUBTOTAL,
BY=2,
BACKCOLOR=RGB(255 252 204),
MACRO=COND0001,
$
TYPE=SUBTOTAL,
BY=2,
BACKCOLOR=RGB(255 128 255),
MACRO=COND0002,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(255 252 204),
$
ENDSTYLE
END

This message has been edited. Last edited by: Kerry,


WebFOCUS developer studio version 7.6.11
Windows
all formats
June 09, 2009, 09:49 AM
GinnyJakes
Mark, please post your code between the code tags (see last icon on the ribbon bar) because we didn't get all of your code especially the styling.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
June 09, 2009, 11:31 AM
Mark
 -* File carsales.fex
SET LINES = 66

TABLE FILE GGSALES
SUM
     UNITS
BY REGION
BY ST
BY CITY
BY PRODUCT

ON REGION SUBTOTAL AS '*TOTAL REGION'

ON ST SUBTOTAL AS '*TOTAL'

ON CITY SUBTOTAL AS '*TOTAL CITY'

ON PRODUCT SUBFOOT WITHIN
" "
HEADING
"Page <TABPAGENO of <TABLASTPAGE "
ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE GGSALES.SALES01.UNITS AS 'TOTAL'
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     INCLUDE = PROBLUE,
$
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     TOPMARGIN=0.250000,
     BOTTOMMARGIN=0.250000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
     DEFMACRO=COND0001,
     MACTYPE=RULE,
     WHEN=N2 EQ 'IL',
$
     DEFMACRO=COND0002,
     MACTYPE=RULE,
     WHEN=N2 EQ 'MO',
$
TYPE=REPORT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     RIGHTGAP=0.125000,
$
TYPE=DATA,
     COLUMN=N1,
     FONT='TIMES NEW ROMAN',
     SIZE=8,
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N2,
     FONT='TIMES NEW ROMAN',
     SIZE=8,
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N3,
     FONT='TIMES NEW ROMAN',
     SIZE=8,
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N4,
     FONT='TIMES NEW ROMAN',
     SIZE=8,
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N5,
     FONT='TIMES NEW ROMAN',
     SIZE=8,
     STYLE=NORMAL,
$
TYPE=TITLE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
$
TYPE=TITLE,
     COLUMN=N1,
     FONT='TIMES NEW ROMAN',
     SIZE=8,
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N2,
     FONT='TIMES NEW ROMAN',
     SIZE=8,
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N3,
     FONT='TIMES NEW ROMAN',
     SIZE=8,
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N4,
     FONT='TIMES NEW ROMAN',
     SIZE=8,
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N5,
     FONT='TIMES NEW ROMAN',
     SIZE=8,
     STYLE=NORMAL,
$
TYPE=FOOTING,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
$
TYPE=SUBFOOT,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
$
TYPE=SUBFOOT,
     BY=4,
     BORDER-TOP=OFF,
     BORDER-BOTTOM=OFF,
     BORDER-LEFT=OFF,
     BORDER-RIGHT=OFF,
     BACKCOLOR='NONE',
$
TYPE=SUBTOTAL,
     BY=1,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=SUBTOTAL,
     BY=2,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=SUBTOTAL,
     BY=2,
     BACKCOLOR=RGB(255 252 204),
     MACRO=COND0001,
$
TYPE=SUBTOTAL,
     BY=2,
     BACKCOLOR=RGB(255 128 255),
     MACRO=COND0002,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(255 252 204),
$
ENDSTYLE
END



WebFOCUS developer studio version 7.6.11
Windows
all formats
June 09, 2009, 11:57 AM
Francis Mariani
The multiple entries in the style-sheet for TITLE is causing the problem.

1) INCLUDE = PROBLUE, is new to me and I don't know if it's a good idea. This uses the PROBLUE style-sheet found somewhere in the App Path, then any other style declarations override the styling that's in the included style-sheet. I have found that it is very easy with the Dev Studio GUI to generate what I believe to be a mess - an included style-sheet AND all the styling also copied into the fex.

2) The best way to debug this problem is to start by commenting all the styling, then add pieces at a time. I did this and found that 
TYPE=TITLE,
     COLUMN=N1,
     FONT='TIMES NEW ROMAN',
     SIZE=8,
     STYLE=NORMAL,
$
clobbers the bottom border 
TYPE=TITLE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-STYLE=RIDGE,
     BORDER-BOTTOM-STYLE=RIDGE,
     BORDER-LEFT-STYLE=RIDGE,
     BORDER-RIGHT-STYLE=RIDGE,
     BORDER-TOP-COLOR=RGB(51 51 153),
     BORDER-BOTTOM-COLOR=RGB(51 51 153),
     BORDER-LEFT-COLOR=RGB(51 51 153),
     BORDER-RIGHT-COLOR=RGB(51 51 153),
$

The TITLE styling should probably be:
TYPE=TITLE,
     BORDER-LIGHT,
     BORDER-STYLE=RIDGE,
     BORDER-COLOR=RGB(51 51 153),
     FONT='TIMES NEW ROMAN',
     SIZE=8,
     STYLE=NORMAL,
$



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
June 09, 2009, 03:02 PM
Mark
Thank you!! I did what you suggested and it worked beautifully. Now I'll try this on my production reports and will (hopefully) get the same results.
Thanks for your insight.


WebFOCUS developer studio version 7.6.11
Windows
all formats