ISO FileMaker Magazine: FileMaker Video Tutorials, Templates, Help & More

Navigation

Video Browser

Scriptology Video Browser

Tools & Resources

Generating Reports From Multiple Tables

Posted by: Editor / Monday, December 3, 2007 – 3:27pm

A support question came in recently, in which it was asked, "What is the best way is to generate reports from data in multiple related tables?".

While there are a number of ways to accomplish this, the best way (I believe) is to use a dedicated Reports table.

Here's my video reply to the question.

Click to watch the video

If you have other suggestions then leave them in the comments area!

About author

Matt Petrowsky is the Senior Editor for ISO FileMaker Magazine. Matt has been involved with FileMaker Pro since the early '90s. Having authored many articles, a popular book, spoken at conferences and seminars, as well as provided private training, Matt is continuously updating his knowledge and skill about the powerful FileMaker platform. You can contact Matt by sending email to editor@filemakermagazine.com.

Filed under: |
login or register to post comments | email this page
-
.

Master with Multiple related tables reporting

.
.
oleung said this on Sunday, February 3, 2008 - 1:32am.
.

Great! Do you mean to export all required data to a table for the content of the report?

Then, we still need to build a layout for the report, right?

It would be great if you can share some experience on how to prepare the layout for printing in this situation.

Thanks,

» login or register to post comments | email this page
.
.

Consolidating multiple tables for one report

.
.
panchristo said this on Thursday, March 4, 2010 - 9:45am.
.

In your video you refer to PDF appending method, can you be more specific on how you can generate separate reports united in one pdf file?

» login or register to post comments | email this page
.
.

PDF Append

.
.
danielbeer said this on Friday, November 5, 2010 - 10:32am.
.

you can use the append to PDF option in the Save as PDf script step to save several different layouts into a single PDF.
Each new layout is appended as a new page, so if you have several half page layouts, you will have several half-full pages in your PDF. It's great for multiple types of reports.

I've done a number of reports using similar methods to the method Matt is talking about and they generally work well.
If you have quite different report types, then appending several reports to a single PDF is great, but if you are just trying to append a range of data from different tables into a single report structure (like the example Matt talks about) then this method works well.

There are obviously up-sides and down-sides to each method.

» login or register to post comments | email this page
.