redbunny78
Programmer
I am trying to calculate total actitvity duration per assignment group. I am using Crystal 9 with an Oracle DB.
The report currently shows the following output:
Ticket #213434
0012345 9/1/07 14:40 9/1/07 14:41
MICH SMITH IBM-SMO Work Performed
1 Mark responded and will check
0012346 9/1/07 15:18 9/1/07 15:56
PETER LINDT SYSOPS-HELP Close Incident
1 Recap
2 System Down @ 1428/1
3 System Up @ 1518/1
4 Resolution/Escalation: IBM-SMO Users were unabl
5 e to access. ODE Support engaged. No delays reporte
6 d. No further updates.
The fields shown above are as follows:
001234.. is the activity number
begin time and end time for the activity
description of the activity which is stored in an array field (see the 1-6 which is the record number)
In conclusion, the output I am looking to add is:
IBM-SMO duration 0.01 hrs
SYSOPS-HELP duration 0.83 hrs
The report currently shows the following output:
Ticket #213434
0012345 9/1/07 14:40 9/1/07 14:41
MICH SMITH IBM-SMO Work Performed
1 Mark responded and will check
0012346 9/1/07 15:18 9/1/07 15:56
PETER LINDT SYSOPS-HELP Close Incident
1 Recap
2 System Down @ 1428/1
3 System Up @ 1518/1
4 Resolution/Escalation: IBM-SMO Users were unabl
5 e to access. ODE Support engaged. No delays reporte
6 d. No further updates.
The fields shown above are as follows:
001234.. is the activity number
begin time and end time for the activity
description of the activity which is stored in an array field (see the 1-6 which is the record number)
In conclusion, the output I am looking to add is:
IBM-SMO duration 0.01 hrs
SYSOPS-HELP duration 0.83 hrs