If I'm reading your post right, you want to know how many of each breed of dog there is at each level - entity, county, district, state, and possibly the report as a whole - all in the same report. Correct?
This is going to get a little complicated if you want the data all in the same report.
Group your report by state, then district, then county, then entity, then breed. Add a "summary" to the breed section that will count the number of dogs for the breed. This will get your counts at the entity level.
If you can do these in separate reports, you can follow this same technique and just remove the inner groups but leave the Breed group. So, your district report would be grouped by: State, District, Breed.
If you must have all of this in the same report, you'll need to do a subreport in the footer at each group level using the same tables as your main report, linking on the groups at the current level or higher, and grouping the subreport on Breed so that you can count the number of dogs per breed at that group level. For example, the subreport in the District group footer would link on State and District.
-Dell
IP Logged
