i have several compound reports that have 3 graphs and a few tables inside each report. My output is PDF. i want to create a PDF that will take all of these reports and create one full PDF. I have tried several different things and all i seem to get is the first report generated and nothing else.

Is this even possible ? If so can someone provide me with an example ?

thanks

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

The first Compound Report has a CLOSE Compound statement - that's why it ends there. I think you'll have to create a "super" Compound report that contains all the components.

Another option that I have done is to use PDFBox to "Join" all the individual PDF reports together.

I've used PDCAT to do the same...

quote:

PDFCAT

I like all the options available.
Seems a bit pricey.

Is there a freebie version ?

We've used PDFTK for years. ( not with WF but with the previous BI-tool ).

PDFTK is freeware an runnable via command line with various parameters.

G'luck

i should specify i have several coordinated compound reports like the one below

 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=Units, TYPE=REPORT, POSITION=(6.25 1), DIMENSION=(4 4), $
END
SET COMPONENT=Sales
TABLE FILE GGSALES
"Sales report for <REGION"
" "
SUM DOLLARS/F8M
BY REGION NOPRINT
BY ST
BY CITY
ON TABLE HOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, FONT=HELVETICA, COLOR=RED, SQUEEZE=ON, $
END
SET COMPONENT=Units
TABLE FILE GGSALES
"Number of unit sales per product for <REGION"
" "
SUM CNT.UNITS AS 'Number of units sold'
BY REGION NOPRINT
BY PRODUCT
ON TABLE HOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, FONT=HELVETICA, COLOR=BLUE, SQUEEZE=ON, $
END
COMPOUND END
 

I think the only ways to concatenate multple compound report together, are:

1. Build a large all encompassing compound layout for all the bits.

2. Use an external concatenation tool like the ones specified above.

jbanas6:

nice indeed.

But that only works if both report have the same first BY field.

What I ( for example ) need is:

TABLE FILE CAR
SUM SALES
BY COUNTRY
END
TABLE FILE CAR
SUM SALES
BY CAR
END

Simplified example to fit the CAR master.
I my real world 'CAR' isn't a subset of 'COUNTRY'.

thanks everyone for your responses

I get so excited when I can actually help someone else with a question on the forum.

Using the Document Composer of Developer Studio, click "Insert", then on "Add Existing Page Layout", choose your existing compound report to add.

I found that it only works if you use the GUI to do this.

Best of Luck.

Michelle

Code looks like:

-* File admit_entry_compound
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
OBJECT=TOC, NAME='text1', TEXT='<font face="VERDANA" size=11 color=#000000>Admit Entry Reports - Table of Contents<BR></font>', MARKUP=ON, TOC-NUMBERING=OFF, POSITION=(0.792 0.792), DIMENSION=(7.000 9.500), font='VERDANA', color=RGB(0 0 0),  size=11, TOC-FILL=DOTS, METADATA=' TOCTITLE: Table of Contents', $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter,  $
PAGELAYOUT=1, NAME='Page layout 1', text='Applicants by Student Type and Gender', TOC-LEVEL=1, BOTTOMMARGIN=0.25, TOPMARGIN=0.25, METADATA='BOTTOMMARGIN=0.25,TOPMARGIN=0.25,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT=' Student Type Report', TOC-LEVEL=2, POSITION=(2.042 0.500), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 4.691in; HEIGHT: 2.184in; OVERFLOW: auto; TOP: 0.5in; LEFT: 2.042in', $
COMPONENT='graph1', TEXT=' Student Type Graph', TOC-LEVEL=2, POSITION=(0.542 2.792), DIMENSION=(7.289 2.124), COMPONENT-TYPE=GRAPH, METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.289in; HEIGHT: 2.124in; TOP: 2.792in; LEFT: 0.542in', $
COMPONENT='report2', TEXT=' Gender Report', TOC-LEVEL=2, POSITION=(2.500 5.292), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 3.769in; HEIGHT: 2.1in; OVERFLOW: auto; TOP: 5.292in; LEFT: 2.5in', $
COMPONENT='graph2', TEXT='Applicants by Gender Graph', TOC-LEVEL=2, POSITION=(0.500 7.417), DIMENSION=(7.292 3.169), COMPONENT-TYPE=GRAPH, METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.292in; HEIGHT: 3.169in; TOP: 7.417in; LEFT: 0.5in', $
OBJECT=BOX, NAME='line1', POSITION=(0.729 5.146), DIMENSION=(7.188 0.050), BACKCOLOR=RGB(220 220 220), BORDER-COLOR=RGB(220 220 220), METADATA='Z-INDEX: 100; POSITION: absolute; BACKGROUND-COLOR: rgb(220,220,220); WIDTH: 7.188in; HEIGHT: 0.05in; FONT-SIZE: 1pt; TOP: 5.146in; LEFT: 0.729in', $
PAGELAYOUT=2, NAME='Page layout 2', text='Page layout 2', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report3', TEXT='report1', TOC-LEVEL=2, POSITION=(1.563 1.042), DIMENSION=(5.521 5.521), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 5.521in; HEIGHT: 5.521in; OVERFLOW: auto; TOP: 1.042in; LEFT: 1.563in', $
END
SET COMPONENT='report1'
-*component_type report
-INCLUDE admit_apps_by_stud_type_report.fex
SET COMPONENT='graph1'
-*component_type graph
-INCLUDE admit_apps_by_stud_type_graph.fex
SET COMPONENT='report2'
-*component_type report
-INCLUDE admit_apps_by_gender_report.fex
SET COMPONENT='graph2'
-*component_type graph
-INCLUDE admit_apps_by_gender_graph.fex
SET COMPONENT='report3'
-*component_type report
-INCLUDE admit_apps_by_stud_type_report.fex
COMPOUND END