When in layout mode delete the Body section (Click on the body and press the delete key). I'm assuming you already have Sub-Summary Sections, Grand Total Section, and Summary Calculations already setup. If not, those aren't too difficult to setup.
Thanks for the quick response. I am fairly new to FMP..........I have a "Count of Records" field. Is this what I need in order to setup the sections you are referring to?
Yeah, in the table you'll want a field with the type "Summary" that can then be count, sum etc. of the field you want to summarize.
In the Report Layout, you'll want to add a part that is called "Sub-summary when sorted by" and you'll select the Field you want to group the records by on the right. You'll then indicate whether it should be above or below the body section. You can then place the Field you want to group by and the Summary field in that section. When you go to Preview mode you'll need to have the records sorted by that Group Field. (Often a script is used to perform the sort for you).
Do a search in the User's Guide for "subsummary" and you should have enough specifics to get what you want:
When doing a grand summary you just add the same Summary field to that part and no sorting is needed.
Hope that gives you enough info...
I think it has. Thanks again!