I'm a newbie to CR and am having a hard time creating a crosstab report. I work for a law enforcement agency. We have a SQL database with tables such as Arrest, Offense, Citation, Warning, etc. Each table list the person who was arrested or received the citation/warning, officer's name, what the person was charged with (speeding, assault, trespassing), etc. I need to complete a report that displays a row for each district and a column that shows the counts of arrests, offenses, citations, and warnings for each district (see below). I need to know how many warnings, citations, etc. were issued by each district. Each table includes the employee name and district.
Warnings Citations Arrests Offenses
District 1
District 2
District 3
I've tried several combinations of Rows, Columns,and Summarized fields in the Crosstab Expert. I'm using the "Count" summary calculation.
Can someone point me in the right direction by telling me what fields should go where in the Crosstab Expert? Any help would be appreciated.