I have a solution for my problem I just want to know if anyone can think of a better answer.

Here is what my problem is: I want to put a top and bottom border on a specific line in a multi line SUBFOOT in a PDF output.

What the issue is: Once I put the line indicator in the stylesheet the borders disappear.

Here is my code that I�m running on WF 5.3.3:

TABLE FILE CAR<br />SUM<br />RETAIL_COST AS ''<br />DEALER_COST AS ''<br />BY COUNTRY AS ''<br />BY CAR AS ''<br />ON COUNTRY SUBHEAD<br />"Country<+0>Car<+0>Retail Cost<+0>Dealer Cost"<br />ON COUNTRY SUBFOOT<br />" <+0> <+0><ST.RETAIL_COST<+0><ST.DEALER_COST"<br />" "<br />"Values for the Country of <COUNTRY"<br />" "<br />ON COUNTRY PAGE-BREAK<br />ON TABLE PCHOLD FORMAT PDF<br />ON TABLE SET STYLE *<br />UNITS=IN,PAGESIZE='Letter',LEFTMARGIN=0.25,RIGHTMARGIN=0.25,TOPMARGIN=0.25,BOTTOMMARGIN=0.00,SQUEEZE=ON,ORIENTATION=PORTRAIT,$<br />-*<br />TYPE=REPORT,FONT='ARIAL',SIZE=8,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,RIGHTGAP=0.00,LEFTGAP=0.00,$<br />TYPE=REPORT,COLUMN=P1,SQUEEZE=1.00,$<br />TYPE=REPORT,COLUMN=P2,SQUEEZE=1.00,$<br />TYPE=REPORT,COLUMN=P3,SQUEEZE=1.00,$<br />TYPE=REPORT,COLUMN=P4,SQUEEZE=1.00,$<br />-*<br />TYPE=SUBHEAD,BY=COUNTRY,BORDER-BOTTOM=MEDIUM,STYLE=BOLD,JUSTIFY=RIGHT,$<br />TYPE=SUBHEAD,BY=COUNTRY,ITEM=1 ,WIDTH=1.00,JUSTIFY=LEFT,$<br />TYPE=SUBHEAD,BY=COUNTRY,ITEM=2 ,WIDTH=1.00,JUSTIFY=LEFT,$<br />TYPE=SUBHEAD,BY=COUNTRY,ITEM=3 ,WIDTH=1.00,$<br />TYPE=SUBHEAD,BY=COUNTRY,ITEM=4 ,WIDTH=1.00,$<br />-*<br />TYPE=SUBFOOT,BY=COUNTRY,<br />LINE=1,<br />BORDER-TOP=LIGHT,BORDER-BOTTOM=HEAVY,BACKCOLOR=RGB(210 210 210),STYLE=BOLD,JUSTIFY=RIGHT,$<br />TYPE=SUBFOOT,BY=COUNTRY,LINE=1,ITEM=1,WIDTH=1.00,JUSTIFY=LEFT,$<br />TYPE=SUBFOOT,BY=COUNTRY,LINE=1,ITEM=2,WIDTH=1.00,JUSTIFY=LEFT,$<br />TYPE=SUBFOOT,BY=COUNTRY,LINE=1,ITEM=3,WIDTH=1.00,$<br />TYPE=SUBFOOT,BY=COUNTRY,LINE=1,ITEM=4,WIDTH=1.00,$<br />ENDSTYLE<br />END<br />-RUN

My solution to the problem: What I did to solve this problem was to create a copy of the COUNTRY field (called CNTRY) and did BY on that field. I then put the second, third and fourth line of the of the COUNTRY SUBFOOT on that CNTRY SUBFOOT. This then allowed me to remove the line indicator on the COUNTRY SUBFOOT stylesheet.

Here is the code to my solution:

 <br />DEFINE FILE CAR<br />CNTRY/A20 = COUNTRY;<br />END<br />-RUN<br />-*<br />TABLE FILE CAR<br />SUM<br />RETAIL_COST AS ''<br />DEALER_COST AS ''<br />BY CNTRY NOPRINT<br />BY COUNTRY AS ''<br />BY CAR AS ''<br />ON COUNTRY SUBHEAD<br />"Country<+0>Car<+0>Retail Cost<+0>Dealer Cost"<br />ON COUNTRY SUBFOOT<br />" <+0> <+0><ST.RETAIL_COST<+0><ST.DEALER_COST"<br />ON CNTRY SUBFOOT<br />" "<br />"Values for the Country of <COUNTRY"<br />" "<br />ON COUNTRY PAGE-BREAK<br />ON TABLE PCHOLD FORMAT PDF<br />ON TABLE SET STYLE *<br />UNITS=IN,PAGESIZE='Letter',LEFTMARGIN=0.25,RIGHTMARGIN=0.25,TOPMARGIN=0.25,BOTTOMMARGIN=0.00,SQUEEZE=ON,ORIENTATION=PORTRAIT,$<br />-*<br />TYPE=REPORT,FONT='ARIAL',SIZE=8,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,RIGHTGAP=0.00,LEFTGAP=0.00,$<br />TYPE=REPORT,COLUMN=P1,SQUEEZE=1.00,$<br />TYPE=REPORT,COLUMN=P2,SQUEEZE=1.00,$<br />TYPE=REPORT,COLUMN=P3,SQUEEZE=1.00,$<br />TYPE=REPORT,COLUMN=P4,SQUEEZE=1.00,$<br />-*<br />TYPE=SUBHEAD,BY=COUNTRY,BORDER-BOTTOM=MEDIUM,STYLE=BOLD,JUSTIFY=RIGHT,$<br />TYPE=SUBHEAD,BY=COUNTRY,ITEM=1 ,WIDTH=1.00,JUSTIFY=LEFT,$<br />TYPE=SUBHEAD,BY=COUNTRY,ITEM=2 ,WIDTH=1.00,JUSTIFY=LEFT,$<br />TYPE=SUBHEAD,BY=COUNTRY,ITEM=3 ,WIDTH=1.00,$<br />TYPE=SUBHEAD,BY=COUNTRY,ITEM=4 ,WIDTH=1.00,$<br />-*<br />TYPE=SUBFOOT,BY=COUNTRY,BORDER-TOP=LIGHT,BORDER-BOTTOM=HEAVY,BACKCOLOR=RGB(210 210 210),STYLE=BOLD,JUSTIFY=RIGHT,$<br />TYPE=SUBFOOT,BY=COUNTRY,ITEM=1,WIDTH=1.00,JUSTIFY=LEFT,$<br />TYPE=SUBFOOT,BY=COUNTRY,ITEM=2,WIDTH=1.00,JUSTIFY=LEFT,$<br />TYPE=SUBFOOT,BY=COUNTRY,ITEM=3,WIDTH=1.00,$<br />TYPE=SUBFOOT,BY=COUNTRY,ITEM=4,WIDTH=1.00,$<br />ENDSTYLE<br />END<br />-RUN

If you can think of a better way around this or if you think this solution is good please let me know.

Curtis,

It appears that using LINE= may not be supported when using the BORDER options. I just checked the documentation and nothing led me to believe that you could.

Your solution is logically correct and works fine for the car file. However, I'd be rather concerned with using this option if you were dealing with larger data sources when doing a sort on a defined field.

Ken