I have a report that has page breaks on the subhead and heading due to requiring the titles to appear above the column headings. This is fine when the report is run with a single selection but fails when 'FOC_NONE' is passed such as the case of bursting the report in RC. The requirement is that the resultant reports show as a separate spreadsheets for each country with the report subhead repeated on each spreadsheet.
Example code
-DEFAULTH &COUNTRY = 'ENGLAND';
TABLE FILE CAR
PRINT
CAR.CARREC.MODEL
CAR.CARREC.MODEL
CAR.BODY.BODYTYPE
BY LOWEST CAR.ORIGIN.COUNTRY
BY LOWEST CAR.COMP.CAR
ON CAR.COMP.CAR PAGE-BREAK
ON TABLE PAGE-BREAK AND SUBHEAD
"This report heading should be repeated for each country and a separate cell for each data field below "
"CAR.ORIGIN.COUNTRY " need to preface with a less than sign
"CAR.ORIGIN.COUNTRY "
"CAR.ORIGIN.COUNTRY "
HEADING
" "
"CAR.COMP.CAR "
WHERE CAR.ORIGIN.COUNTRY EQ '&COUNTRY.COUNTRY:.';
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
BACKCOLOR=RGB(155 155 155),
$
TYPE=HEADING,
LINE=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
BACKCOLOR=RGB(205 205 205),
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
BACKCOLOR='WHITE',
$
TYPE=HEADING,
LINE=2,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=1,
BACKCOLOR=RGB(205 205 205),
$
ENDSTYLE
END

This message has been edited. Last edited by: I.P.,

Not sure why you added page break to ON TABLE line. Your table file syntax should be in below format.

TABLE FILE CAR
PRINT
MODEL
BODYTYPE
BY COUNTRY
BY CAR
ON COUNTRY PAGE-BREAK
ON TABLE SUBHEAD
"HEADING LINE 1"
"HEADING LINE 2"
HEADING
"PAGE HEADING"
END

Thanks,
Ram

I would like to burst the report on the Country and have a report output of the following with the line spacing preserved

England
Heading Line 2

Jaguar
Model BodyType
V12XKE AUTO CONVERTIBLE
XJ12L AUTO SEDAN

Jensen
Model BodyType
Interceptior IIISedan

Triumph
Model BodyType
TR7 Hardtop

France
Heading Line 2

Peugeot
Model BodyType
504 4 Door Sedan

Found a workaround. Using the REPEAT clause and dumping the subsequent reqports as separate files to a drive.