Dear Folks,
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
IP Logged