Theodore
February 14th, 2007, 08:23 PM
Hi,
I am pretty new to Crystal 8.5 and am having problems using formulas on a group summary field.
The database is > 1 million records and I am trying to group a field (for quicker report generation). The field is the time (in seconds) numeric and I want to be able to manipulate this field and get it into hhhh:mm:ss format.
In this application, I want to add up all the seconds for each person in a department, then give a total for each person however in hh:mm:ss format.
Eg Person Table
Name Duration(in seconds)
Peter 50
John 10
Peter 45
John 22
John 80
Peter 100
The Crystal generated SQL will generate
Peter 195
John 112
This is straight forward, however, I now need to convert this to hh:mm:ss format to give me
Peter 00:03:15
John 00:01:52
I can do the above if I look at each individual record (ie no grouping) and use formulas on the Duratin field, however, because of the size of the database, I want to group the records and then manipulate the SUM (Person."Duration") field.
Does anybody have a solution?
(I hope my explanation of my problem is clear ...)
Thanking you in advance.
Theodore
I am pretty new to Crystal 8.5 and am having problems using formulas on a group summary field.
The database is > 1 million records and I am trying to group a field (for quicker report generation). The field is the time (in seconds) numeric and I want to be able to manipulate this field and get it into hhhh:mm:ss format.
In this application, I want to add up all the seconds for each person in a department, then give a total for each person however in hh:mm:ss format.
Eg Person Table
Name Duration(in seconds)
Peter 50
John 10
Peter 45
John 22
John 80
Peter 100
The Crystal generated SQL will generate
Peter 195
John 112
This is straight forward, however, I now need to convert this to hh:mm:ss format to give me
Peter 00:03:15
John 00:01:52
I can do the above if I look at each individual record (ie no grouping) and use formulas on the Duratin field, however, because of the size of the database, I want to group the records and then manipulate the SUM (Person."Duration") field.
Does anybody have a solution?
(I hope my explanation of my problem is clear ...)
Thanking you in advance.
Theodore