quote:

Syntax: How to Create a Compound Layout Report With Document Composer Syntax

In this simple example using the Car Master File, the MERGE keyword specifies that a Coordinated Report is to be generated. Since the first BY field of each component is COUNTRY, a page will be generated for each value of COUNTRY, with the first report (Sales) positioned at (1 1) and the second report (Fuel) at (6.25 1).

Enter the following syntax in the Text Editor tab of the Document Composer.

SET PAGE-NUM=OFF
COMPOUND LAYOUT PCHOLD FORMAT PDF
SECTION=S1, LAYOUT=ON, MERGE=ON, ORIENTATION=LANDSCAPE, $
PAGELAYOUT=1, $
COMPONENT=Sales, TYPE=REPORT, POSITION=(1 1), DIMENSION=(4 4), $
COMPONENT=Fuel, TYPE=REPORT, POSITION=(6.25 1), DIMENSION=(4 4), $
END
SET COMPONENT=Sales
TABLE FILE CAR
"Sales report for " "
SUM SALES
BY COUNTRY NOPRINT
BY CAR BY MODEL
ON TABLE HOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, FONT=HELVETICA, COLOR=RED, SQUEEZE=ON, $
END
SET COMPONENT=Fuel
TABLE FILE CAR
"Fuel efficiency report for " "
BY COUNTRY NOPRINT
BY HIGHEST MPG
BY CAR BY MODEL
ON TABLE HOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, FONT=HELVETICA, COLOR=BLUE, SQUEEZE=ON, $
END