Formula to total only certain records

[Abner2]

I have a report showing a list of arrested subjects by officer. I have all of names of people arrested for felony arrests in red. Now I want to have a total at the bottom of the report - a count for felony arrests and a count for misd. arrests. In other words, all of the names in red to have a total and all of names in black to have a seperate total. Any suggestions?

 

[dgillz]

what is someone is arrested more than once? Should it count just once or the number of times the person was arrested. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[Abner2]

Actually that is my other problem. The are times when one person is arrested for several different charges regarding one incident. In that case I want it to count as just one arrest. On the other hand if the person was arrested two or more times by the same officer regarding different incidents I want that to count as 2 or more arrests.

 

[dgillz]

Abner2, is there a booking number or something else we could count rather than the person's name? Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[Abner2]

aHH yes, and that worked - I now have a more accurate count of arrested subjects - but I still need to figure out how to have seperate counts for those arrested for felonies.

Thanks

 

[dgillz]

Create a running total field, make it a count field on the booking number, evaluate based on a formula, make the forumla {ArrestType}="F", reset=never. This or something similar should work for Felonies.

Make a similar running total for misdemeanors. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[Abner2]

Okay, I have one more problem. I have two seperate reports - one lists the name of the people arrested by a particular officer. The second is a crosstab report listing all of the officers and a count of their arrests. The number of felony arrests are higher on the crosstab report than on the first report. I am wondering if it has to do with doing a running total of booking numbers on the one report and doing a distinct count of booking numbers on the cross tab. Any idea?