Summary report in CR 2008

[2012385096]

Hi,

I need help to create below summary report. The report is group by Department and need to count FileID for each column values by department.
For example:

Service Department
ErrorCategory TypeOfError ErrorDesc
User = 11 Random = 9 Failure to follow up = 6
Examiner=1 PG = 3 Others = 3
Misc = 3

IT Department
ErrorCategory TypeOfError ErrorDesc
User = 6 AA = 4 Incorrect data = 2
Examiner = 2 PG = 4 Other = 2
Misc = 4

The values of each columns are not fixed. It could be any error and also any number of errors.

Your help is greatly appreciated. Thanks in advance.

 

[Madawc]

Sounds like a crosstab. These can be found under Insert on the menu and are a useful option. Try some and learn how they work.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP