Generating a summary report
So I pretty much have my head wrapped around creating simple report layouts using summary fields and sub-summary parts and so on. However, I'd like to create a simple, one-page "comprehensive report" layout that summarizes information that at the moment I generate on several separate report layouts.
For example, suppose you have a dog walking company and you keep a database to track your activities each day. You might track DATE, TIME, TYPE OF DOG, HOME COMMUNITY and TYPES OF TREATS GIVEN. By creating summary fields I can COUNT the number of different types of dog, or the number of dogs per community etc. and generate count reports for each: "Summary by dog type" or "summary by community."
But is there a way to create a single document that says from date X to date Y, "I walked so many of this type of dog, and so many of that type of dog"; and on the same page/layout also have "I walked this many dogs in this community and this many in that community" and so on??
I hope that makes sense. Anyway... suggestions??