I have been tasked with creating 2 crystal reports of closed support tickets. I only know the very basics of creating a report.

The first report would list the call types (category) with the total closed for the requested month. I was able to add the field and add a summary (count)for each call type. That works fine.
The second part of this report is to create a chart to include the last 12 months of closed tickets. I have searched Google and tried different options in Crystal with no luck.

The second report would list the call types (category) and the extended call types (subcategory). I was able to add those fields and add the summary (count) to display the number of total closed tickets for the call types and below that each extended call types would show the number of closed for each.
I basically took the first report and added the extended call type field but then the number of records showed me 20,0000+ when it should only be around 486. I'm not sure what I'm doing wrong and how I would get the counts to display correctly.

Any help would be greatly appreciated.

Thanks,

Tom

The fields are from 2 different tables