General information
Category:
Reports & Report designer
Title:
Count in footer band incorrect
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only