I am working on crystal Reports 9 in building a tempalte to achieve a specific kind of reporting format. Appreciate your help.

 

Table Name:	Activity Audit
Name	Activity Code	Total Time Spent (secs)
Brian	Lunch	536
Abhi	Mail	86953
Mike	Mail	5689
Brian	Mail	5686
Mike	Ticket	5896
Abhi	Lunch	3623
Expected report format
Full Name	Lunch	Mail	Ticket
Brian	0:52:06	0:46:06	0:00:00
Abhi	0:46:06	2:46:06	0:00:00
Mike	0:52:06	0:52:06	0:52:06

 

Thanks,

Abhi