Grouping by city, Counting Records

[purdybirds]

I have Crystal Reports 9. I have a report from a database grouped by city. All I want is to show how many records there for each city and place the number next to the city name. I don't want to show any fields, just the number of records for each city. Can anybody help?

[brucevde]

I don't have Crystal 9 but things should be the same.

You need to create a summary field. In 8.5 its on the Insert Menu -> Summary. Fill in the boxes appropriate for your report.

You would want to choose "Count" or "Distinct Count" for the "Insert a field which calculates the "

Once you click ok, a new field is added to a group footer.