I have several reports that are compound documents. They all start off by getting data from an SQL database and then they populate reports based on that data. The "individual" reports are made up of several FEXs that end up as a PDF.

I'd like to combine all of these reports together so that I can run just one FEX and have the full PDF, but I can't seem to get the syntax right to do a compound compound document.

Some might be thinking - why not just do one giant compound report, but i'd have to redo a fair amount of work to in order to fix things so I don't have a dozen "page 1" headers, etc.

any ideas?

My guess is you can't do a "compound compound report" - the close compound command will close the whole report. I'm not up to speed on v7.6.5, but I thought I read in one of the FocalPoint postings (or could it be just my imagination running away with me?) that you can concatenate existing PDF documents, so, perhaps, using FILEDEF you can create the individual compound reports and then concatenate them to make the final report.

Since you are running 765, you can use the PDF Layout Painter to do what you want. You can use a Page Master to do the page numbering for you instead of the individual reports.

It is a great tool. Check it out.

Since you already have fexes created, create another one and choose PDF Layout Painter as the tool. Then once inside, reference your existing fexes as external reports.

I also tried this a while back and it just didn't work out. I don't have the newest Layout painter, but 7.1 does handle the new syntax for compound reports (without page master functionality.)

Your best bet is just to redo it in the PDF Layout, referencing your existing focexecs, and letting it handle things like page numbers. Let us know if you figure something out.

Thanks for the comments. I'll try the PDF Layout Printer. It's new to me (I was on 7.1 until about two weeks ago).