Here is the SQL used in one of the drill-through reports referenced by footyref above. The report is sorted in Cognos by Cnty Cd, Caseload Nbr, and Case Nbr and grouped similarly. There are also total case counts calculated by report, county, and caseload.
The primary fact table is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.