Like my subject line says, I've inherited a Database in Filemaker 5.5. There are 12 related databases which contain figures from invoices which have been paid to 5 different accounts over time. Each payment has an account, country, category, sub category and item, amount, and payment quarter attached to it. I need to be able to see all the payments by by country, with the sum of the items grouped by subcategory, by payment quarter, while being able to compare the figures of each account. I'm trying to decide which tool to use to begin creating this layout. Any suggestions??

It might be most efficient to import the data you need from all the files into a single reporting file. At that point you might need nothing more than a simple subsummary report.