Are you able to produce each individual summary report?
That's step 1. Creating Filemaker Pro summary reports--Tutorial
Can you script the production of each individual report?
Step 2 Scripted Find Examples
Can you use a script to save a PDF of a single layout?
Last step is to stitch this altogether taking advantage of the Append option in save as PDF to append each summary report to the PDF generated with the production of the first PDF
Let me know where you need specific help in putting together these steps.
Thanks Phil !!! You are such a legend !!
Will update you on the progress. Cheers.
So I tried in vain, to put together a whole script to meet my objectives of having FM, generate a single pdf file ( which contains one single project_id, with multiple layouts, generated as a single pdf file.
The issue now is, my script seems to be stuck in an infinity loop.
I think the issue lies where I am trying to push each project_id through each layout and setting the is_generated ="Y" once they have gone through the loop.
Please help.Thanks in advance.
How can I help when I can't see what you have set up?
To post a script to the forum:
- You can upload a screen shot of your script by using the Upload an Image controls located just below Post a New Answer.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here. (with this approach, you can get multiple script steps on the same line, please edit the pasted text by inserting some returns to separate those steps.)
- If You have FileMaker Advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format.