

Each individual part isn’t too hard to do: some web viewers, a sub-summary report or two, and a list report. This report should show the week’s totals on the first page, then summary information about how many new customers ordered from you, broken down by region, a list of aggregate sales information for top selling products, and a list of every order that was returned.īefore FileMaker 9, this would have been a very difficult report to produce. You decide you want everybody to have a special report in their in box every monday morning. As business grows, it becomes more and more important to get the right data in the hands of your employees, so they can make good decisions. Here’s the deal: You operate a web retailer. The Advisor Basics version goes in to more detail, and covers page numbering and security considerations.

>Note: An expanded version of this tip will appear in the next issue of *Advisor Basics of FileMaker Pro*, a great magazine for folks learning FileMaker.

Once you see it in action, you’ll agree it is very useful. Luckily, you can do all this (and more) with the new Append to PDF feature in FileMaker 9. Of course you can just print several reports one after the other, but that doesn’t help if you want to *email* the report as a PDF, or store it on the file server. How many times have you wanted to produce a report that showed *two different* lists of records? Or a couple pages of summary information, then a list of raw data? Or a title page, then a few pages of charts, then one list of data, then a few more charts, then a second list? In FileMaker, reports are tied to layouts, and a layout is tied to just one table.
