I have a compound report that I am trying to add Title Borders too. I have a style sheet for each report but when I run the report the only one that looks right is the last one on the report. The other reports have the Border lines all scrambled on the report.

There are 6 reports total and they all print out on the same page of the Excel document. The first reports end with
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK

-INCLUDE marketing/style_rolling_12.fex

The middle reports end with
ON TABLE PCHOLD FORMAT EXL2K NOBREAK

-INCLUDE marketing/style_current_yr_rpt_1.fex

And the last report ends with

ON TABLE PCHOLD FORMAT EXL2K CLOSE
-INCLUDE marketing/style_brokerage_rpt_1.fex

If I comment out all includes except the first one the report looks ok for the first report. When I bring in the second include for the second report, the second report looks ok but the first report has a Top-border put on the last two columns. It just gets worse the more includes I put back in.

Any help would be greatly appreciated.

This message has been edited. Last edited by: <Kathryn Henning>,

Here is my code.

ON TABLE SET STYLE *
UNITS=IN,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=TITLE,
COLUMN=N1,
BORDER-BOTTOM=LIGHT,
$
TYPE=TITLE,
COLUMN=N2,
BORDER-BOTTOM=LIGHT,
$
TYPE=TITLE,
COLUMN=N3,
BORDER-BOTTOM=LIGHT,
$
TYPE=TITLE,
COLUMN=N4,
BORDER-BOTTOM=LIGHT,
$
TYPE=TITLE,
COLUMN=N5,
BORDER-BOTTOM=LIGHT,
$
TYPE=TITLE,
COLUMN=N6,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N7,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N8,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N9,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N10,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N11,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N12,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N13,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N14,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N15,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N16,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N17,
BORDER-BOTTOM=LIGHT,
STYLE=BOLD,
$
TYPE=HEADING,
JUSTIFY=CENTER,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=REPORT,
COLUMN=N7,
WRAP=.5,
$
TYPE=REPORT,
COLUMN=N8,
$
TYPE=REPORT,
COLUMN=N9,
WRAP=.5,
$
TYPE=REPORT,
COLUMN=N10,
WRAP=.5,
$
TYPE=REPORT,
COLUMN=N11,
WRAP=1,
$
TYPE=REPORT,
COLUMN=N12,
WRAP=1,
$
TYPE=REPORT,
COLUMN=N13,
WRAP=1,
$
TYPE=REPORT,
COLUMN=N14,
WRAP=1,
$
TYPE=REPORT,
COLUMN=N15,
WRAP=1,
$
TYPE=REPORT,
COLUMN=N16,
WRAP=1,
$
TYPE=REPORT,
COLUMN=N17,
WRAP=1,
$
ENDSTYLE
END

In the PAGEMASTER syntax of the fex i would use the object syntax to draw any lines/borders in a compound report.
In other words don't use the BORDER-BOTTOM etc in table file requets rather use the following syntax in the pagemaster:-
OBJECT=LINE, POSITION=(6.250 1.500), ENDPOINT=(6.250 8.2),BORDER-COLOR=GRAY,$

Also I should add that to get the grid around a title in compound report I set the grid off in the report syntax and for each TYPE in the style sheet I set the GRID=ON
Example
TYPE=REPORT,GRID=OFF,$
TYPE=TITLE,COLUMN=COUNTRY,GRID=ON,$
TYPE=DATA,GRID=ON,$
This should give you what you need.

How would I code it if I wanted to put a line under TYPE=GRANDTOTAL,

All I need to do is separate each report with a line but the row counts change depend on the number of rows printed for each report. One county may have two rows where another may have 10.


Thanks

I see. To underline when the sort breaks to grand total you would have to maybe use
TABLE FILE CAR
SUM SALES
BY COUNTRY
ON TABLE SUMMARIZE
ON TABLE SET STYLE *
TYPE=GRANDTOTAL,STYLE=BOLD+UNDERLINE,$
ENDSTYLE

END
-RUN

Here's a trick that works, providing that you're not using TABLE HEADING for somthing else:

TABLE FILE CAR
. . .
ON TABLE SUBFOOT
""
. . .
TYPE=TABFOOTING, COLOR=RED, BORDER-TOP=HEAVY, BORDER-BOTTOM=OFF, BORDER-LEFT=OFF, BORDER-RIGHT=OFF,$
. . .
ENDSTYLE
END

Ok, thanks for all the help on this....

Helper and Doug, both examples worked like a great. The customer is happy with the results so I can move this into production.

I went with the code that Helper sent because it allowed me to use the same style sheet for each compound report. Doug’s code would work but because the column count changes in each report, and I would have to use a different style sheet for each report so that I could count the columns.

Thanks again.

No Problem. But, how is: "TYPE=TABFOOTING, COLOR=RED, BORDER-TOP=HEAVY, BORDER-BOTTOM=OFF, BORDER-LEFT=OFF, BORDER-RIGHT=OFF,$" affect by the number of cloumns?

Hi Guys,
I think when using a compound report any syntax of BORDER-TOP=HEAVY etc etc causes a problem with the layout. I use the BORDER only on non compound reports and it works great.