- Enter layout mode.
- Use duplicate layout to make a copy of your summary report,.
- Delete the body so that only the team names and summary count field remain in the sub summary part.
Properly sorted, this will give you the list you want.
I did that and it is still coming out in thirty pages. I tried just putting team and count and it had every individual player not with their name just team and the count,
Did you delete the body from the layout?
In layout mode, click the "body" part label and press delete to delete it.
All that I had in the layout was the sub summary I deleted everything else I had in there
What version of FileMaker are you using? 10 or 11?
With older versions, you have to preview this to see the result.
Don't see how that gets you thirty pages if the body layout part has been deleted.
You should already know this, but you still have to sort by team. just like your original layout.
I'll try again I have filemaker pro 10 thank you for all of your help on this
It worked, now I want to try for the same thing with total salary cap, it should work