Listing the Managers for a dept. on a page for each page. Is this possible in FM?

[Thumperman]

Hi-

I am having a problem thinking of a way to list all of the managers for a department for each page. (There are hundreds of departments). The current page break is department but each department contains multiple managers. Currenty, Filemaker is only listing the first manager on that page instead of all managers. Is this possible in FileMaker. I can't use a global field because the information will change for each page. Please help. Thanks in advance for any response.

Thumperman

[danjacoby]

Create a sub-summary part when sorted by department.

[Thumperman]

Actually, I want the list of names to be in one field in the header. I am able to create a global field that will list all of the department managers for the entire report but that list is very long. I just want the field to (calculate or script) it to list only the managers for that department for that page. So this field will change from page to page. I hope this makes sense. I currenly do have a subsummary by department in my body. Thanks.