AnsweredAssumed Answered

Generating a summary report

Question asked by FMNewbie on Apr 18, 2012
Latest reply on Apr 19, 2012 by FMNewbie


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??