I have a report that is fed by this sql.

SELE C.NAME,;
B.ADDRESS, B.CITY,;
P.FNAME,P.LNAME;
FROM COMPANY C JOIN BRANCH B;
ON C.ID = B.PARENTID
JOIN PEOPLE P;
ON B.ID = P.PARENTID

So I have multiple companies, that have multiple branches, that have multiple people.

I have 2 data grouping bands, one on CompanyID, and one on BranchID

In the footer of the CompanyID band I am trying to count the number of branches in the company. I am putting a field "branchID" and calculting "Count", resed on CompanyID.

This count is giving me a count of the detail band, ie # of people in the company, instead of branches in the company.

In the report summary band I am putting a count of CompanyID, reset end of report, but it too is giving me a count of the detail band for the entire report.

Any Ideas on what switch I am missing?

Thanks,
Terrence